Importing TopoJSON file in power bi

[Anonymous]

Hi all,

This is the first time I am using the shape map visual with custom map. I have .dbf, .prj, .shp, .shx files. In mapshaper.org, I leave the default checkmarks and import the four files. I chose "Prevent shape removal" to 5%. But here is the screen shot of what I am getting.

I checked posts on forum regarding this but nothing helped. (https://community.powerbi.com/t5/Desktop/From-Shapefile-to-TopoJSON-for-shape-map/m-p/69691 and other posts as well)

If anyone would be able to give a hint to make this work would be great. Also, let me know if any information is needed.

Thanks,

Supriya

[lbendlin]

As you know the earth is not a sphere. It's more like a pear.  There are a variety of projections that are approximating that shape, WGS (world geodetic system) 84 (introduced in 1984) is one of them.

[Anonymous]

@Anonymous 

Take a look at this post: https://community.powerbi.com/t5/Power-Query/Importing-TopoJSON-file-to-create-shape-map-what-Next/td-p/857202

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nandukrishnavs]

@Anonymous 

If you are trying to generate a custom map, use http://mapstarter.com/

Then download the TopoJson file and use it in the Shape map visual.

Another point, in your snapshot I could see "!" icon. Hover over to that icon understand the error.

[lbendlin]

hard to tell without seeing sample data.  As long as the topojson is well formed it should work. Did you maybe inadvertently remove the categories? 

[Anonymous]

Hi @lbendlin , @Anonymous , @nandukrishnavs ,

I am using mapshaper.org to convert the shape file to topojson format.  And I am having a table with SMALL_AREA as one of the column which I guess should map with topoJSON file. I put this field in the Location field of the shape map and then in the format section I added the json file by clicking on Add map option.

here is the link of my topojson file generated from mapshaper.org.

https://drive.google.com/file/d/1FT9mW93S_v5j2Lyf-VRqymit3GrXX2nZ/view?usp=sharing 

In one of the posts, it was written to check View Map keys in the format section.  But my PBI just froze when I clicked on it. I guess there us some problem in my topoJSON file. I don't have much idea on the format of the json file.

Regards,

Supriya

[nandukrishnavs]

@Anonymous 

The link is not accessible.

[Anonymous · Accepted solution]

Hi all,

I was able to solve the problem by using proj wgs84 command in console in the mapshaper and then exported the topojson format. Now I am able to see the map.

Thank you.

[GlassShark1]

What does "proj wgs84" do exactly? Having the same issue with my visual, but mapshaper doesn't like this command for me, so i'm guessing it's referring to something specific
"Unable to project -- source coordinate system is unknown"

[Anonymous]

@nandukrishnavs , My apologies. Here is the link-

https://drive.google.com/drive/folders/1t94KGlXZ0Lc2y_3clZvn4g73TAKeAs_c?usp=sharing

Let me know if this works.