Forum Discussion
Bing Map Address Not Geographically Correct
Hello,
I am using Bing Map to plot the ship-to location of various customers. I need this to be able to filter by state.
I put all the information in the most correct format I could (Address, City, Zip, State) and plotted. For 99% of the data points, it is accurate. But for some reason a few get plotted oddly. Below is an example, filtering for California I get 8 data points that are not in California, but looking at the tooltip I see that the data point should be plotting to somewhere in California:
The data center I use does not have longitute or latitude information, and I don't want to use longitude or latitude data since the time it would take to map these cities to the appropriate long+lat coordinates would take forever (I've tried).
Is there any way I can format the data for Bing to correctly plot the address?
Thank you,
Rob
2 Replies
Hi Anonymous
Without longitute or latitude information, only information including "Address, City, Zip, State" may be confuzed for there are same names for different "Address, City, Zip, State".
To avoid this, please select the any column of columns "Address, City, Zip, State" , select proper type in Modeling->Data category.
It is better to add longitute or latitude information, you can search documentation and examples of longitute or latitude and use it in Power BI.
Please find more details here.
https://sqldusty.com/2016/04/26/power-bi-and-the-bing-maps-api/
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
