Add kml data to a PowerBI shape map

[rgreen001]

I have been sent mapping data in the form of a .kml file and I want to add that data to an existing Power BI shape map visual.

How can I do that?

I have tried importing the file into mapshaper.org (and can see it there) and then exporting back into a .csv file but the resulting file doesn't contain any location parameters.

I can export from mapping.org into a topoJSON file but that creates me a new shape map file which I don't want. I want to get the .kml data into an existing shape map file.

Thanks

[rgreen001]

Thank you. I will give that a go.

[lbendlin]

you can ingest the .kml directly in Power Query. Parse the XML and create a flat table with lat lon pairs.  You'll lose all the ornaments but you can parse these separately if needed.