Solved: Re: Problem using custom shape map - Page 2

ChristianDiscer · ‎08-04-2016

Converted shapefile (projection "transverse_mercator") to a Topo JSON file using the website http://mapshaper.org/ but the resulting JSON file has display problems. Here's a screenshot: (1) The left image displays the shapefile in ArcGIS. (2) The top & bottom right are the JSON maps displayed within PBI using different projections.

ScreenCapture

I've even "simplified" the edges of the original shapefile to reduce the number of verticies before converting to JSON.

FYI - The location attributes (from an excel file) are correctly applying to the different areas within PBI.

Any ideas of what I should do? Thank you.

Power BI version: 2.37.4464.361 64-bit (July, 2016)

Windows version: Windows 7 Pro 64-bit (SP1)

deldersveld · ‎08-16-2016

I believe that when I converted your file, I lined it up with WGS 84 / EPSG 4326 -- geographic.

View solution in original post

ChristianDiscer · ‎08-16-2016

@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

View solution in original post

oblitasss · ‎04-17-2018

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

amarcos · ‎09-21-2016

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?

androidtemplar · ‎11-21-2016

Hi!

The GeoJson you had behind the link has things throwing PowerBI off,

it has Scandinavian chars (e.g. &auml = ä "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

androidtemplar@outlook.com