Creating the right longitude and latitude

[Anonymous User]

Hi!

I am currently working on a dataset that I first worked on in ArcGIS Pro, to allow more calculations I then exported it to Excel and after that to Power BI. In ArcGIS I created X and Y coordinates assigned to each hexagon because I thought that would allow me to use ArcGIS for Power BI but when I try to load in my data using those X and  Y coordinates, it is displayed in a row as can be seen in the image.

I am quite new to working with Power BI and I am not sure how to resolve this issue, how can I best fix this?

[AndreasHall]

There seems to be something wrong with your coordinates. It looks like all your points have the same Latitude. (As all your points are "in a row" from east to west.)

You should add your coordinates like this to the wells in Power BI.

[Anonymous User]

Thank you for your reply! I checked my latitude and longitude in my original table and added part as an image below. It shows different values, so I am unsure where it's going wrong. I also added it to my Power BI, as shown in your picture.

[AndreasHall · Accepted solution]

I think your coordinates are in the wrong format. Make sure they are WGS84 and in a supported notation format.

Prepare your data—ArcGIS for Power BI | Documentation

---

Use specific latitude and longitude values

Latitude and longitude values represent an x,y coordinate location on the map. You can map x,y coordinate data using the World Geodetic System 1984 (WGS84) coordinate system. In this system, latitude (y) values range from -90 to 90, and longitude (x) values range from -180 to 180. You can also use DMS (Degrees, Minutes, Seconds) notation to map your data; for more information, see Supported notation formats.

---

[Anonymous User]

Thank you! That turned out to be the problem!