using map visual with lamber 93 coordinates

[tekcimo-96]

Hello, i have a problem, i would like to display points on a power BI map visual, my coordinates are in lambert 93 and the native power BI visuals only support the attitude and longitude coordinates. is there another visual i can dowload and use or an easy method without using Python or convert the coordinates to display the points on a visual ? Thank you

[v-sshirivolu]

Hi @tekcimo-96 
Thank you @SolomonovAnton  for the helpful response!

I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question

Thank you.

[v-sshirivolu]

Hi @tekcimo-96 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Thank you.

[tekcimo-96 · Accepted solution]

Hello, my problem is resolved, i used the python programe to convert directly on power querry, thank you 

[v-sshirivolu]

Hi @tekcimo-96  ,
I'm glad to hear that your query was resolved! Please accept your answer as accept as solution to ensure that the solutions shared are valuable for the entire community.

Thank you for your cooperation.

[SolomonovAnton]

Power BI's native map visuals require coordinates in the WGS84 system (latitude and longitude). Since your data is in Lambert 93 (EPSG:2154), you'll need to convert these coordinates to WGS84 to visualize them correctly.

Option 1: Convert Lambert 93 to WGS84 in Power Query

You can perform the conversion directly within Power BI using Power Query (M code). Here's a simplified example of how you might approach this:

// Placeholder M code for converting Lambert 93 to WGS84
// Note: Implementing this conversion requires complex mathematical formulas
// or external libraries, which are not natively available in Power Query.
// Therefore, consider using external tools for the conversion.

Implementing the Lambert 93 to WGS84 conversion in Power Query is complex and may not be practical due to the mathematical intricacies involved. It's recommended to use external tools or services to perform this conversion before importing the data into Power BI.

Option 2: Use External Tools for Coordinate Conversion

Consider using external tools or services to convert your Lambert 93 coordinates to WGS84. Some options include:

• EPSG.io Coordinate Transformation

After converting the coordinates, you can import the resulting latitude and longitude values into Power BI for mapping.

Option 3: Utilize Custom Map Visuals Supporting Lambert 93

If converting coordinates externally is not feasible, consider using custom map visuals that support Lambert 93. One such option is the Mapbox Visual for Power BI:

• Mapbox Visual for Power BI

Mapbox allows for custom projections and might support Lambert 93 with appropriate configuration. Note that using Mapbox may require an access token and adherence to their usage terms.

Recommendation

For simplicity and performance, it's advisable to convert your Lambert 93 coordinates to WGS84 using external tools before importing the data into Power BI. This approach ensures compatibility with Power BI's native map visuals and avoids the complexities of implementing coordinate transformations within Power BI.

If you need assistance with the conversion process or configuring custom map visuals, feel free to ask!

✔️If my message helped solve your issue, please mark it as Resolved!

👍If it was helpful, consider giving it a Kudos!