Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : u0Qb7mf98iqZDN3G6ouGoh
Microsoft Cloud for Sustainability | MSM, SDSF,...
Answered

Import Region Mapping automatically?

Like (1) ShareShare
ReportReport
Posted on 3 Mar 2025 09:26:03 by 41
Is it possible to import the region mapping via the Import functionality?
The entity is not available in the Excel template for reference data nor can it be found as a source category under the import via Power Query Connector option.
 
Thank you.
 
 
  • Verified answer
    Ivan (Vanya) Kashperuk Profile Picture
    on 17 Mar 2025 at 14:38:53
    Import Region Mapping automatically?
    Yes. We have Country/Region, Geographic Area, Geographic Area Type.
    What we're missing is "Related Geographic Area" which is used to relate a geo area to various different entities or itself to create a hierarchy in a temporal manner (meaning, it'll have dates to make the relationship effective only for a particular period, for example). It'd support types of relationships like "Contains", "Is part of", "Borders", "Overlaps", etc.
  • Joke Laukens Profile Picture
    41 on 17 Mar 2025 at 14:09:47
    Import Region Mapping automatically?
    @Ivan (Vanya) Kashperuk, but my recap is correct?
     
    There will be a new feature allowing to link the country/region table to the geography area table. This will allow for a flexible way to group country/regions in a hierarchical fashion. This functionality will replace the region mapping in the company profile.
     
    The geography area and geography area type table are already available, however the link tot the country/region table is not yet released.
  • Ivan (Vanya) Kashperuk Profile Picture
    on 17 Mar 2025 at 13:11:37
    Import Region Mapping automatically?
    Unfortunately timelines are uncertain at this point.
    I would not expect it in the next 6 months
  • Joke Laukens Profile Picture
    41 on 17 Mar 2025 at 10:33:23
    Import Region Mapping automatically?
     
    Let me recap your answer to make sure I fully understood.. Can you please confirm correctness?
     
    There will be a new feature allowing to link the country/region table to the geography area table. This will allow for a flexible way to group country/regions in a hierarchical fashion. This functionality will replace the region mapping in the company profile.
     
    The geography area and geography area type table are already available, however the link tot the country/region table is not yet released.
     
    Any indication on timeline? I'm not finding it in the 'What's new and planned' of the release waves..
     
    Thanks.
  • Suggested answer
    Ivan (Vanya) Kashperuk Profile Picture
    on 17 Mar 2025 at 04:37:01
    Import Region Mapping automatically?
    So I was thinking of "Geographical area" which was in combination with the new country/region table allow for a very flexible way of configuring regions / areas / countries / etc in a hierarchy.
    However looks like that part of this feature was delayed for other priorities.
     
    We however also don't really have the intention of improving this legacy one. So I guess just add them manually or through power automate or similar for now
  • Joke Laukens Profile Picture
    41 on 14 Mar 2025 at 10:56:10
    Import Region Mapping automatically?
     
    Could you follow up on this topic? 
     
    Thank you!
  • Joke Laukens Profile Picture
    41 on 06 Mar 2025 at 08:04:06
    Import Region Mapping automatically?
    Hi Ivan,
     
    We intended to use it as it is described in MSFT documentation: A region mapping makes reporting and analysis more flexible.
    It would be, sort of, an additional attribute to the country dimension, making it possible to report emissions etc. on a higher level than country.
     
    Can you elaborate on how the country/region setup could be used to realize a similar solution?
     
    Thanks.
  • Ivan (Vanya) Kashperuk Profile Picture
    on 04 Mar 2025 at 16:16:20
    Import Region Mapping automatically?
    Soo, that is indeed not possible today. But I am curious why and how you plan to use this data?
    We've sort of been thinking of removing it completely, since we now have the more flexible Country/Region setup.
     
    Can you explain your plans for this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,916 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,782 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading started