I cannot visualize correctly topojson files in powebi

[EU]

I follow the instructions to convert a shape file to topojson (WGS84 system, transformed to geojson with qgis and then to topojson with mapshaper) but when I try to visualize it with powerbi, the file and the geometry seems to be empty. What is the correct way/path to charge the topojson file in powerbi and to visualize? Thanks for the help.

[Anonymous]

Hi @EU,

Using this link http://geojson.io  you can convert geojson as well as topojson. Although after converting file it should necessary that whatever region name is taken in topojson code that region name should match with you table data.

Hoping this will help you, If not could you please share your sample pbix file. That will helpful for me to solve your issue.

Best Regards,

Ravi

[EU]

Hi Ravi,

Thanks for your answer. With the link I convert the file but still dont visualize data or geometry in power bi. Wich is the best way to upload the topojson file in powerbi? Do I need to upload the data in another file (excel for example)? I feel that I'm missing some step...

Thanks!

Elena

[Anonymous]

Hi Elena,

No, For uploading topojson file , you just need to

1.click on shape map then 

2.Click on format pane 

3.Open Shape option 

4. Just import your topojson file.

Again if it is not coming could you share any sample of your file if possible. I will look into that.

Best Regards,

Ravi

[Anonymous]

Or just share geojson file and region name for which region you want to see data.

[EU · Accepted solution]

Finally I discover what were the problems:

1) I need to activate in general options: To enable Shape Map, select File > Options and Settings > Options > Preview Features, then select the Shape Map Visual checkbox.

2) Then, I need to charge one table with data in powerbi.

3) Start with shape map.

4) Click on one of the columns/data of my table. This serve to activate the possibility of charge my own map in topojson format.

5) And finally... I discover that it works better if the map is almost empty of data (just with the ID code -the same in the table with data-) and the data is in the table I included in power bi in step 2.

Thanks for the help!!!