Forum Discussion
Problem using custom shape map
- 10 years ago
I believe that when I converted your file, I lined it up with WGS 84 / EPSG 4326 -- geographic.
- 10 years ago
deldersveld Thank you so much, that works great!! Here's are screen captures of the process.
Step #1: select the shapefile using ArcGIS Project tool & set parameters
Step #2: Parameters selected
Step #3: Use mapshaper.org to convert shapefile to json format
Step #4: Save as TopoJSON
Step #5: Use TopoJSON file in Power BI:smileyvery-happy:
deldersveld Thank you so much, that works great!! Here's are screen captures of the process.
Step #1: select the shapefile using ArcGIS Project tool & set parameters
Step #2: Parameters selected
Step #3: Use mapshaper.org to convert shapefile to json format
Step #4: Save as TopoJSON
Step #5: Use TopoJSON file in Power BI:smileyvery-happy:
ChristianDiscer: Great. I don't have an ArcGIS license, and I used QGIS. If/when I blog this, can I use your screenshots for ArcGIS users alongside my own?
- mjfulke9 years ago
Microsoft Employee
I was able to take Shape Files straight to http://MapShaper.org, import them, and in the Console window, run -proj wgs84 and convert the map to something Power BI would accept.
- sweidlich8 years ago
Advocate II
This response needs to be ranked higher. Our security settings at work prevent us from installing qgis, and arcgis is too expensive. But running "-proj wgs84" in the console dialog worked like a freaking charm.
- ChristianDiscer10 years ago
Advocate I
Yes, by all means use the images in anyway possible. Thanks again for your help!!
- deldersveld10 years ago
Resident Rockstar
Did a quick writeup on it here: https://dataveld.wordpress.com/2016/09/01/overcoming-potential-power-bi-shape-map-rendering-issues/
- amarcos10 years agoRegular Visitor
Can you help me
i want to use some countries shape maps that are not in Power BI, for example Finland, i downloaded the GeoJSON file from here
http://code.highcharts.com/mapdata/
Finland http://code.highcharts.com/mapdata/countries/fi/fi-all.geo.json
Then I opened in http://mapshaper.org/ and exported as TopoJSON
When i open it in Power IB I can not see the map onliy lines as previous user
Can you help me?
- amarcos10 years agoRegular Visitor
Can you help me
i want to use some countries shape maps that are not in Power BI, for example Finland, i downloaded the GeoJSON file from here
http://code.highcharts.com/mapdata/
Finland http://code.highcharts.com/mapdata/countries/fi/fi-all.geo.json
Then I opened in http://mapshaper.org/ and exported as TopoJSON
When i open it in Power IB I can not see the map onliy lines as previous user
Can you help me?
- androidtemplar9 years ago
Advocate I
Hi!
The GeoJson you had behind the link has things throwing PowerBI off,
- it has Scandinavian chars (e.g. ä = ä "Itä-Uudenmaan maakunta") - reading this evening through several stack traces when trying to feed multipolygon GeoJson for PowerBI, it just rolls down and cries if it sees something outside Latin1. meh.
- according to validation feedback from GeoJsonLINT the GeoJson you have there also does not follow the right hand rule, which seems to be a thing also.
Having run around internjets for a moment now seeking for a suitable source, I am not seeing a clean WGS-84 compliant, right-hand rule -following GeoJson of Finnish borders, let alone one with e.g. postalcode area geographies. I will do something about it (create one, validate it, test it with PowerBI) tomorrow and be back. In case I succeed and you are still struggling with this, ping me at
- oblitasss8 years agoNew Member
I have tried for weeks to convert to the correct projection, but it does not work... could someone convert this shape to topojson please? I have tried with QGIS, ARCMAP, used http://mapshaper.org/ but it continues showing in powerbi the Picaso Effect, The link of the shape is this : https://drive.google.com/file/d/1kbY_HkCulQzWD8SgJkP9nHu9bjmILY3U/view?usp=sharing
- Anonymous8 years agoNot applicable
Hi there. Will you please be able to help me with the similar problems? Thank you in advance. My email [email protected]
- sf095 years agoFrequent Visitor
Hi, I'm having this issue with shape maps in powerbi so I think your writeup on the solution might be exactly what I need (I know almost nothing about ArcGIS!) but when I follow the link I get, "
Private Site
This site is currently private. Log in to WordPress.com to request access."
I don't have a WordPress login so I wondered if there's any other way I could access this please?
- ahohnstein1 year agoNew Member
This worked for me, thank you.