Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
vinter
Frequent Visitor

From Shapefile to TopoJSON for shape map

Hi.

 

Like a few others, I am having trouble converting SHP files into the TopoJSON needed for the custom shape maps.

 

I download from a govermental site, and choose SHP file(s) and choose the only avaliable UTM/ETRS89 (prev. EUREF89). The four resulting files are shared here

 

In mapshaper.org, I leave the default checkmarks and import the four files. I simplify choosing "Prevent shape removal" to 5% and choose Repair on the 13 line intersections. The resulting, exported TopoJSON file is also in the shared folder

 

However, when imported into Power BI Desktop's new Shape Map, the result is not what one could wish for:

 

Capture.JPG

I hope one of you will be able to give a hint as to how to make this work. It looks like such an awesome and much needed feature! Thanks for any help!

 

(I am btw aware of this post, which does not solve my problem).

 

1 ACCEPTED SOLUTION

Turns out, the solution was to only add the SHP file to QGIS not the entire collection. I think, that's what fixed it, but the important thing: It works now.

View solution in original post

5 REPLIES 5
kpmaster2k
Frequent Visitor

Hi, 

 

links and tools required 

 

Tutorial
https://danielcorcoranssql.wordpress.com/2017/08/08/qgis-cropping-and-converting-shp-files-to-topojs...

 

Transform or Convert GeoJson to TopoJson

http://mapshaper.org/
basic http://jeffpaine.github.io/geojson-topojson/
 

Magic Secret 
EPSG:4283 , this format is allowed by PowerBi


QGIS

https://qgis.org

Mrecords
Frequent Visitor

Hi, 

 

I also face trouble in converting a polygons SHP to TopoJSON. 

Converting with mapshaper or mygeodata.cloud, I get a file which displays boundaries correctly in PowerBi, but doesn't have any attribute. What should I do to preserve the fields (like district name, province name, population, etc.)?

 

Thanks

SylviaMDR
Frequent Visitor

Have you checked this topic? I had the exact same problem as you do, and the solution there worked for me.

Turns out, the solution was to only add the SHP file to QGIS not the entire collection. I think, that's what fixed it, but the important thing: It works now.

Thanks for you answer. 

 

I should have noted that too, but yes I have and it did not work 😞

I should probably try a followup in that thread or the blog post mentioned there.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.