Forum Discussion
Address works in PowerView and Power Maps but PowerBI won't plot correctly (HELP)
If it works in Power View, then it should work in Power BI as well. So it might be just data categorization issue.
Could you make sure the Data category is set to Address? If this doesn't solve the issue, could you send us the pbix file? You can either upload it as attachment or use the Send a Smile/Frown feature in Power BI Desktop to send the file to us.
Point well taken about the diff between PMap and PBI...i just thought the Geocoding part of it would be pretty close.
I'll try starting with a more managable location set i can test and see what PBI likes better (formating) ...i just figured since 99.9% were failing i must have a more fundamental problem going on amd someone else might have already solved/ figured out a work around. I'll update if i make any progress.
Thnx Eno.
Resolver IVIf it works in Power View, then it should work in Power BI as well. So it might be just data categorization issue.
Could you make sure the Data category is set to Address? If this doesn't solve the issue, could you send us the pbix file? You can either upload it as attachment or use the Send a Smile/Frown feature in Power BI Desktop to send the file to us.
I'm having much the same experience, where complete street addresses are being plotted in 'default' locations in Power BI Desktop (e.g. centre point of the corresponding state capital), but seem to resolve correctly in Power View. The same address when pasted into Bing Maps resolves perfectly as well.
I've noticed this behaviour for quite a number of addresses, even when using a complete format of:
[Street No] [Street Name] [Road Type] [Suburb], [State], [Country]
Variants of this address formatting will either not plot at all, or plot in the same incorrect location. For problematic addresses I've not been able to find a variant that plots correctly in Power BI Desktop, although Power View and Bing Maps will both correctly plot several variations.
The field is categorised as 'Address'.
