bing map transformation and coordinate system

[susiechen]

I want to use the bing map in power bi.

At first, I use the xy from wgs84 coordinate system. There is data shift and the points can't show properly.

So I try to use the simple calculation formula result of lat and long.

The points show better, but not exactly the right place.

Is there any info about bing map transformation and coordinate system?  So that I can get the excat xy from arcmap?

thx!

[Anonymous]

@susiechen,

Do you drag any field to Location of Map visual? In your scenario, you can create a custom column concatenating place and country, set proper  Data Category for this new field, then drag it to Location of the map visual with  Latitude and Longitude fields.

For more tips, please review the following article and video.
https://docs.microsoft.com/en-us/power-bi/power-bi-map-tips-and-tricks
https://www.youtube.com/watch?v=fhyfXcsXI9c

Regards,
Lydia

[susiechen]

Yes, I tried to drag field to Location of Map visual and it dosen't work.

The points I want to show on map is in Macau SAR, Asia. Maybe the geocoding is not working here.

The main problem is I don't know how to change the xy in WGS84 to bing map transformation and coordinate system xy.

Thanks for your advice anyway.

[Anonymous]

I have the same problem.