Forum Discussion
Community ChampionWhy the difference in map location between desktop and service?
Good evening everyone, and above all, happy new year!
Can anyone shed any light on why there is a discrepancy between the physical depiction of an address in the map visual in desktop vs what is seen in the service? I am using the default map visualisation and using an address field formatted as "Place" in the table column.
Here is what I see in Desktop (which is correct):
And here is how it is rendered in the service:
Just to confirm the above, here is the rogue location depicted by Bing maps (on the web) using the same address:
Hi Marcus,
Just as a follow up on this issue, and for the benefit of others who may be encountering similar inconsistencies, I came across Christos Samaras' blog in which he offers a VBA script for Excel which auto-magically gets the coordinates (latitude and longitude) for any address through Google's geocoding service (free up to 2,500 requests a day). The process does require users to set up an account in Google's Cloud Platform.
Basically once you have the VBA script running in a workbook, + a couple of other settings which are described in the text/notes within the script itself, you can have a column of addresses in a sheet within the workbook and run the functions in adjacent columns to obtain the coordinates for each address.
I have tried it out and it works beautifully!
His blog is here
It would be great if Microsoft offered something similar with a BING API.
10 Replies
- mwegener
Most Valuable Professional
Hi PaulDBrown ,
Power BI makes a localized BING map request.
What language do you use in Power BI Desktop. (Try English-US)
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
PaulDBrownThanks Marcus for taking a look at this.
My Power BI Desktop is in fact in English-US, though my Windows is in Spanish (I'm based in Spain).
Having said that, the rogue address (I've actually located at least another address which is rendered wrongly) is shown correctly in Desktop; it's once it's uploaded to the service that the location is wrong (which I find confusing, if not worrying).
I'd hate to have to resort to finding the lat-long coordinates manually to ensure the correct location settings (which of course directly undermines one of the benefits of BI).
Thanks again.
- mwegener
Hi PaulDBrown ,
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
