PowerBI Repeatedly Crashing

[mwscipio]

I am attempted to make an animated map showing the shipment the teams sends that day. I finally had the data pulled from its sources, and transformed to the point where it would work fine when I was initially building the report. Once everything looked good, I saved and clicked Publish so I could go online to PBI and generate a URL link so I could share with the team.

Once I navigated to PBI online, I saw the report & data set there, but when I clicked on it I recieved an error (out of memory). Not sure what happened, I tried to go back and re-open the report on PBI desktop and received the same error (screenshot below). It was just working a second ago!!!

I had this issue last night so I found some other suggestions on this board and have already tried 1) deleting as many unneeded columns from my data sources as possible, 2) ensuring I didn't have any duplicated column names throughout the process, 3) reverted back to a Feb 2020 version of PBI desktop. None of that worked...

Background on my data:

1. Source 1 - local excel document that has all of the US zipcodes and their lat/long coordinates
   • many thousands of rows, but only three columns
2. Source 2 - MySQL database that holds the team's shipping records
   • Query returns about 6 columns and only 13 rows (# of rows will change given the number of orders we have, but it will usually be between 5 and 20 rows)
3. Data Transformation
   • Start with results of MySQL query
   • Run simple R script on the results so I can use RegExp to parse out the zip code data from each query record
   • Join query results to the zipcode data base so I have a lat/long point for the Origin and Destination of the shipment
   • Run R script on each Origin/Destination pair that calculates n-number of intermediate coordinates between the origin and destination (I chose 50)

[v-yuta-msft]

@mwscipio ,

I would suggest you create a support ticket here for further analysis.

 

Regards,

Jimmy Tao