Forum Discussion

rgreen001's avatar
rgreen001
Frequent Visitor
3 years ago

Add kml data to a PowerBI shape map

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

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    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.