cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper IV

## Plotting maps using Eastings & Northings

I have data that includes National Grid Reference (NGR) data for plotting individual points. I can fairly easily convert this to eastings and northings - so I essentially have either that I can use.

However, when creating maps my only option is using Latitude and Longitude - which I don't have.

Is there a way to use my Eastings and Northings to plot points or do I need to convert to Lat Long. If I need to convert, how do I do that? Very struggling on this and would apprecaite any help that anyone can offer.

I think it would be really helpful for Microsoft to include Eastings and Northings for plotting maps but in the meantime any help welcome.

4 REPLIES 4
Frequent Visitor

I'm joining in late here, but if you have your data in a table, you can use this tool to batch convert between XY and Lon/Lat:

https://gridreferencefinder.com/batchConvert/batchConvert.php

Employee

@Back2Basics,

You would need to convert eastings and northings to Latitude and Longitude, you can perform the process using R script following the guide in the blogs below.

Converting from UTM to Lat, Long
Convert Universal Transverse Mercator (UTM) coordinates to longitude-latitude coordinates in R

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IV

I have absolutely no experience of R. The suggestions from these links look a bit complicated for me.

Basically I have an easting column and a northing column. How would I go about putting these into something so that for each row it produces the lat/long so that I can plot the point?

Sorry for my iggnorance, still learning.

Employee

@Back2Basics,

You would need to install R studio and required R package to execute the R scripts.

Another easy way is to use Online tool to convert Eastings & Northings to lat&long, then save your data in flat file, connect to the flat file in Power BI Desktop and create map.

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors