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
Microsoft Eric_Zhang
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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors