cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shbjv
New Member

shape map chrashes when loading JSON file

I have got a TOPOJSON file created in Map Shaper I load it as custom maps it looks fine, but then POWER crasches and I get the enclosed error message.

 

I have tried to send the file and the enclosed error message to support without reaction. Any ideas on what to do?

 

Feedback Type: Frown (Error)

Timestamp: 2016-08-09T12:39:14.9210483Z

Local Time: 2016-08-09T14:39:14.9210483+02:00

Product Version: 2.37.4464.461 (PBIDesktop) (x64)

Release: July, 2016

IE Version: 11.0.9600.18163

OS Version: Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 da-DK)

CLR Version: 4.5.2 or later [Release Number = 379893]

Workbook Package Info: 1* - da-DK, fastCombine: Disabled.

Working set: 467 MB

Peak Virtual Memory: 3.92 GB

Error Message: We’re sorry, a problem occurred while rendering this report and the application must close.

User ID: 426a6599-a243-43e3-b1ac-e24021ad8fe9

Session ID: cf0ae50e-a498-44fa-8f67-a7d7257e5dc0

Telemetry Enabled: True

Model Default Mode: Import

Snapshot Trace Logs: C:\Users\shbjv\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot195020970.zip

Performance Trace Logs: C:\Users\shbjv\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features: PBI_allowDrillGrouping PBI_shapeMapVisualEnabled PBI_allowBiDiCrossFilterInDirectQuery

Disabled Preview Features: SapBusinessWarehouse PBI_RedShift PBI_Impala

Enabled DirectQuery Options: DirectQuery_Unrestricted

Formulas:

 

 

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: shape map chrashes when loading JSON file

Your computer's specs should not be an issue. The file was a very high resolution shapefile, and in addition, there was a lot of coastline detail. Try this version, which has been simplified: https://www.dropbox.com/s/2pd06z2ptvita8f/KOMMUNE-simplified.json?dl=0

 

In general, Power BI will have difficulty with high detail, larger topojson files. Your posted JSON file is about 12MB, and this new one is a little over 1MB. I was able to simplify to 0.75% in mapshaper without much noticeable difference at a high-level zoom. See if that works for you.

KOMMUNE.PNG

 

 

View solution in original post

Re: shape map chrashes when loading JSON file

I used the Simplify functionality in mapshaper and reduced it to 0.75%. That may have some distortion at a low level, but it did not impact the shapes at a high zoom level.

View solution in original post

6 REPLIES 6
Highlighted
Microsoft
Microsoft

Re: shape map chrashes when loading JSON file

@shbjv

 

I was trying to reproduce the crash with TOPOJSON from this Github repository, However the shape map looks good after import and no crash occurs. So would you share the TOPOJSON used in your case?

 

By the way, I see "Peak Virtual Memory: 3.92 GB" in the error message, usually the memory outage causes application crash. What is your PC OS and is there enough memory?

Re: shape map chrashes when loading JSON file

shbjv
New Member

Re: shape map chrashes when loading JSON file

My OS is Windows 7 and I have 8GB Ram so a peek og 3.92 GB should not be a problem or is it?

 

I have placed both the JSON file and the files used to create the JSON file in the following folder:

https://www.dropbox.com/sh/peacd0774lb1uuk/AAB7B4e0EC3uDIH2vGgMjoILa?dl=0

Re: shape map chrashes when loading JSON file

Your computer's specs should not be an issue. The file was a very high resolution shapefile, and in addition, there was a lot of coastline detail. Try this version, which has been simplified: https://www.dropbox.com/s/2pd06z2ptvita8f/KOMMUNE-simplified.json?dl=0

 

In general, Power BI will have difficulty with high detail, larger topojson files. Your posted JSON file is about 12MB, and this new one is a little over 1MB. I was able to simplify to 0.75% in mapshaper without much noticeable difference at a high-level zoom. See if that works for you.

KOMMUNE.PNG

 

 

View solution in original post

shbjv
New Member

Re: shape map chrashes when loading JSON file

It is working perfect, I have a lot of keys, but that should be possible to do something about. What did you do to make it simple? Thanks a lot for your help.

Re: shape map chrashes when loading JSON file

I used the Simplify functionality in mapshaper and reduced it to 0.75%. That may have some distortion at a low level, but it did not impact the shapes at a high zoom level.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

Top Solution Authors
Top Kudoed Authors