topic Re: Coordinates error in power bi in ArcGIS for Power BI Questions

Coordinates error in power bi

SatyamChaturvedi — Fri, 21 Jun 2024 02:12:50 GMT

Hi,

I am trying to publish a map in Power BI, but I'm encountering an error related to the coordinates during validation. I'm unable to identify where the error is or which coordinate is causing the issue, making it difficult for me to fix it. I am attaching a screenshot for more information.

Re: Coordinates error in power bi

MdeBoer — Fri, 21 Jun 2024 08:54:30 GMT

Hi, it looks like you still have data in the location field well. You cannot publish a map when this is the case unless it is JSON data. In this documentation you can find more information about publishing: https://doc.arcgis.com/en/microsoft-365/latest/power-bi/publish-to-web.htm#:~:text=Power%20BI%20data%20used%20to%20create%20the%20ArcGIS%20for%20Power%20BI%20map%20must%20use%20latitude%20and%20longitude%20coordinates%20for%20locations%20or%20EsriJSON%20in%20the%20Location%20field%20well.%20If%20the%20Location%20field%20well%20contains%20addresses%20or%20standard%20boundaries%2C%20publishing%20to%20the%20web%20will%20fail..

Re: Coordinates error in power bi

NaZhang_Esri — Fri, 28 Jun 2024 22:57:01 GMT

Hi @SatyamChaturvedi,

And thanks @MdeBoer for the reply! That's right! Since there are data added both in the Location and XY field wells, it fails the embed and publish check. So please remove "Village name" from Location field well. Power BI only allows one Power BI data layer added. Once XY is mapped, data added to the Location well won't be mapped.

Please let me know if you have more questions! Thanks!

Re: Coordinates error in power bi

SatyamChaturvedi — Sat, 29 Jun 2024 04:40:12 GMT

Thanks brother for support.

Re: Coordinates error in power bi

DillionRoberts — Tue, 23 Jul 2024 16:59:44 GMT

I am running into the same issue, but I don't have anything in the location field well, only in the latitude and longitude. @MdeBoer @NaZhang_Esri How can I fix this issue?

Re: Coordinates error in power bi

NaZhang_Esri — Tue, 23 Jul 2024 17:27:37 GMT

Hi @DillionRoberts,

From your screenshot, I see you added "Address:Zip/Postal" data to both XY data. Coordinates works if you add XY data in. Address data will need to put in the Location field well to be mapped. Please refer to this link to see the adding data process. Add a data layer to a map.

Thanks!

Re: Coordinates error in power bi

DillionRoberts — Tue, 23 Jul 2024 18:02:11 GMT

Would it be possible to use an address, zip/code, city, etc. in the XY field since I am trying to embed this map to a website? Or does it have to be XY data only?

Re: Coordinates error in power bi

NaZhang_Esri — Tue, 23 Jul 2024 19:43:58 GMT

You could use other data than XY and put in the "Location" field well, but it has to be EsriJSON format if it's not XY in order to embed.