Pretty much all maps in Power BI require your point data to be in longitude and latitude – but often our spatial data is in Eastings and Northings. In this video blog I walk through the what, why and how for converting your spatial data to longitude and latitude directly within Power BI, including a free download sample PBIX file with the custom Power Query function and supporting table for central meridian. I’ve adapted the example script from the Power BI (now Fabric) community forum post (https://community.fabric.microsoft.co...) to parameterise the central meridian to allow conversion of data across multiple UTM zones at once.

If you're keen to explore the Power BI report and download DiscoverEI’s free sample PBIX file with the Power Query script that we walked through in this video, then check out the Power BI report and blog here: www.discoverei.com/blog/powerbimappingconverteastingsnorthingstolonglat

If you're interested in learning more about Power BI applications for the environmental industry, then head on over to our website for project examples: https://www.discoverei.com/, take a look at our exciting training courses: https://www.discoverei.com/training, check out our blog posts: https://www.discoverei.com/blog or join in the fun with the community at our #PowerBI4Enviros Meetup group: https://www.meetup.com/enAU/powerbi4...

This video is part of DiscoverEI's Maps for Power BI series, please subscribe for more videos about maps. Thanks for watching and have fun exploring mapping techniques for Power BI!