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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

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
Anonymous
Not applicable

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

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.