Forum Discussion
Automatically reproject coordinates from Euref89 --> WGS84
Hello
I'm wondering if it's possible in Power BI to do a reproject of coordinates by some kind of formula?
I will have several datasets with coordinates in EPSG25832 (UTM 32N) that I wouild like to be converted to WGS84 that works in Power BI visulisations. The reason for not doing it outside Power BI is that we will be changing data source (same structure in the data and but can't chance the source structure), so if everything is run in Power BI that would be the optimal solution. I know QGIS/Arcmap etc. can reproject easily, but it's not a valid solution to do it there first.
Source coordinate X/Y are in this:
ETRS_1989_UTM_Zone_32N
WKID: 25832 Authority: EPSG
Projection: Transverse_Mercator
False_Easting: 500000,0
False_Northing: 0,0
Central_Meridian: 9,0
Scale_Factor: 0,9996
Latitude_Of_Origin: 0,0
Linear Unit: Meter (1,0)
Geographic Coordinate System: GCS_ETRS_1989
Angular Unit: Degree (0,0174532925199433)
Prime Meridian: Greenwich (0,0)
Datum: D_ETRS_1989
Spheroid: GRS_1980
Semimajor Axis: 6378137,0
Semiminor Axis: 6356752,314140356
Inverse Flattening: 298,257222101
I need them changed to this coordinate system so it works in Power BI:
GCS_WGS_1984
WKID: 4326 Authority: EPSG
Angular Unit: Degree (0,0174532925199433)
Prime Meridian: Greenwich (0,0)
Datum: D_WGS_1984
Spheroid: WGS_1984
Semimajor Axis: 6378137,0
Semiminor Axis: 6356752,314245179
Inverse Flattening: 298,257223563
2 Replies
- themistoklis
Community Champion
Anonymous
The best option for you is to find a good python library that converts any coordinates to WGS84
PowerBI supports python scripting, which you can use in transformation layer.
A good python library, called pyproj, can be found in this link:
Sounds interesting, if I add a Python Library to a pbix file, would that mean it follows the pbix?
It's because I would like to create a Standard Pbix file that I can just change the datasource in and exchange that with my colleagues as the structure of the datasource will always be the same.
Next step is learning how the Python script works, as I know basically nothing about Python.
