Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I get an Excel file with lambert 93 GPS points
Example :
X93 | Y93 |
389003.92283526 | 6324484.1235129 |
I would like to convert into a GPS point with latitude and longitude so taht I can use it in a Map visual :
pointGPS |
-0.875659260 43.950656461 |
Thanks for your help,
Jérôme
Solved! Go to Solution.
While I strongly believe that you can do the conversion before getting into Power BI, here is an old thread :
Otherwise I would go for using Python for example :
from pyproj import Proj, transform
lambert93 = Proj(init='epsg:2154') # Lambert 93
wgs84 = Proj(init='epsg:4326') # GPS coordinate system, WGS84
def convert_lambert93_to_wgs84(x, y):
lon, lat = transform(lambert93, wgs84, x, y)
return lat, lon
# Example of conversion
x93, y93 = 389003.92283526, 6324484.1235129
lat, lon = convert_lambert93_to_wgs84(x93, y93)
print(f"Latitude: {lat}, Longitude: {lon}")
While I strongly believe that you can do the conversion before getting into Power BI, here is an old thread :
Otherwise I would go for using Python for example :
from pyproj import Proj, transform
lambert93 = Proj(init='epsg:2154') # Lambert 93
wgs84 = Proj(init='epsg:4326') # GPS coordinate system, WGS84
def convert_lambert93_to_wgs84(x, y):
lon, lat = transform(lambert93, wgs84, x, y)
return lat, lon
# Example of conversion
x93, y93 = 389003.92283526, 6324484.1235129
lat, lon = convert_lambert93_to_wgs84(x93, y93)
print(f"Latitude: {lat}, Longitude: {lon}")
Thanks for your answer but I don't understand where you put your code : "
from pyproj import Proj, transform
...
use it before going to Power BI. (the language is Python)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |