nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Find more posts tagged with

Accepted answers

AndreasHall

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.

All comments

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

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!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.