Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a list of addresses in a column in my table, in the following format:
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |