cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NovaBI
Helper III
Helper III

Way to create Geo-coding (Long-/Latitude) from an adress

Hi all,

 

is there an "integrated" way in PBI to create Longitude and Latitude data from adresses.

 

E.g. let's say we got Country,State,Zip,Street, Building

 

and I want to create the two dimensions from that?

 

I know that there are some workarounds like using BingMapsPortal and register as DEV and use an API Key...and so on.

I do not like this approach too much as I do not want to register and I am not sure if the API Key is permanent.

 

Second one is creating a R script within PBI or using R (Studio) to create my own maps. But as people are used to use the standard map from PBI, I'd like to stick to that approach.

 

So, is there any conversion within PBI Desktop that does that job already that it's possible to create 2 columns for the long/lat data?

2 REPLIES 2
v-angzheng-msft
Community Support
Community Support

Hi, @NovaBI 

 

Here are some references that might help

https://community.powerbi.com/t5/Desktop/Geo-codes-to-use-for-mapping/m-p/1201750

https://community.powerbi.com/t5/Desktop/ZIp-code-map-in-power-BI/m-p/1087043

https://community.powerbi.com/t5/Desktop/How-to-create-postal-code-geo-dimension/m-p/188894

 

 

Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-angzheng-msft ,

 

not exactly what i was looking for. I am using now Bing-geo data via the API, but it looks like PBI Service is not able to process dynamic sources as my solution works in Desktop, but not in Service. I will open another thread on this. Thanks

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!