Forum Discussion
Full address not plotting on Bing map
I have a list of addresses in a column in my table, in the following format:
- Street address, town/city, post code/zip code, country
I have addresses all over the world: USA, Germany, France, UAE, UK.
Only around 1/3 of the addresses are showing. However when I enter the addresses into Bing Maps in my browser, they all work.
Is there a way to get Bing Maps in Power BI to accurately plot my addresses? I have tried tinkering with the addresses by putting the post codes after country, but with no luck.
Thanks
Hi shaunguyver,
Based on my test, if you want to show all of the city addresses, you can refer to below steps:
Create a map visual and add the [City] column to the ‘Location’ bucket and add the ‘Full Address’ to the ‘Tooltips’ bucket, now you can see all the detail city addresses.
You can also download the PBIX file to have a view.
Regards,
Daniel He
3 Replies
Hi shaunguyver,
Could you please offer me which countries could not display in the map or could you please share pbix file if possible? If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.
Regards,
Daniel He
Hi - there's no sensitive info so please see below dropbox link to the PowerBI file. I've stripped it down so there is only a dataset with the addresses, a slicer for the properties, and a Bing Map Visual linked to the full address:
https://www.dropbox.com/s/3r7kxrmocw9xemo/Dashboard%20-%20Map%20Test.pbix?dl=0
Thanks in advance for your help, it's really appreciated
Hi shaunguyver,
Based on my test, if you want to show all of the city addresses, you can refer to below steps:
Create a map visual and add the [City] column to the ‘Location’ bucket and add the ‘Full Address’ to the ‘Tooltips’ bucket, now you can see all the detail city addresses.
You can also download the PBIX file to have a view.
Regards,
Daniel He
