I have a .shp file that I want to use in my Power BI dashboard, however I keep running into multiple issues. Because Power BI only accepts TopoJSON for its shape maps, I have to do some transformations.
In QGIS, I've ensured the CRS is WGS84. However, when I load it into mapshaper.org along with the .prj file, it tells me that it's missing projection data. I inspect the .prj file in Notepad++ and see that it has a CRS.
This is where I got with my data set before I didn't get further, but out of curiosity I tried continuing with a dummy data set. I used mapshaper.org to convert the data into GeoJSON, and then copy pasted the GeoJSON into geojsonlint.com to validate it. All good, so I imported it into Power BI, and voila I have a map (albeit with the wrong data set).
Is there an easier way to do all of this? I've spent quite a few hours trying to get this pipeline to work.