Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ohhhhhhfffs
Regular Visitor

Conversion of East North values to Lat and Long values for Mapping

HI i have a bunch of Easting/Northing co-ordinates that id like converted to Lat/Longs to show on the map visualisation in Powerbi

 

I know i can use external software and convert the values however the values will be coming in via an powerapp in easting/northing due to an old piece of hardware.

 

I have tried using the following

https://community.powerbi.com/t5/Quick-Measures-Gallery/Northings-and-Eastings-to-Latitude-and-Longi...

 

However the values i get are incorrect, im assuming that the guy wrote that for his grid not my grid, is anyone able to show myself how to do this? or how they have done it.?

Thankyou

1 ACCEPTED SOLUTION
3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @Ohhhhhhfffs,

I'd like to suggest you use web connector to invoke correspond convert rest API to handle these data conversion instead of manually calculations.

Solved: Pull data from a REST API Authentication - Microsoft Power BI Community

java - Convert easting and northing to latitude longitude cordinates - Stack Overflow
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hey mate,

 

Any chance you could break down the steps a bit further for me?

 

The easting and northings i need to convert are recorded by fellow workers and are currently kept in a sharepoint database,

 

The way i manually do it is i use this site https://geodesyapps.ga.gov.au/grid-to-geographic

Which after selecting the zone it batch converts the easting and northing to lat and longs.

 

Im confused to what exactly im supposed to do with your answer? Is the Rest API Just for getting data off the web? so am i supposed to find a site that converts?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors