Forum Discussion
Impactful IndividualBig report crashes
I had a big report which crashes and now it tries refresh, but the refresh is so big that it can't do it all at once. Any way you can import the data step by step?
Otherwise I have to get back to the previous version and apply all changes I did (and hope I don't miss out on anything) on that version based on the crashed file...
8 Replies
- SpartaBI
Community Champion
Is your data partioned?
If yes, you can refresh specific partions with Tabular Editor or SSMS one after ther other, but pretty sure you need Premium or PPU
DouweMeerYou may refer to Power BI Service, I'm talking about Power BI Desktop.
On a crashed report it state "there are pending changes", which can't be discarded. Any attempt to import separatly results in the mentioning of 'please apply or disregard first'.
- SpartaBI
The PBIX isn't suppposed to carry out huge amounts of data. Maybe you reached the MAX memory possible for your PC.
For that you have the incremental refresh capability so the service will take on the heavy lifting there.- DouweMeer
I hit that limit in the past. I now have 64 GB laptop RAM, which is sufficient for my 2.4 GB report. But the crash happened on smaller reports.
Hi DouweMeer ,
Could you please tell me what is your connectiion way?
How about reducing the size of the pbix file? Please refer to the following blog to see if it helps you.
How to Reduce the Size of Power BI file in a few Steps
-
Open Power BI Helper as an external tool
-
Remove columns with big memory space consumption as much as possible
-
Step 2: Turn off the Auto Date/Time
-
Step 3: Remove un-used columns
If I have misunderstood your meaning, please provide you pbix file without privacy information and your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- DouweMeer
I sometimes have 3 or 4 reports running at the same time, but the RAM consumption is no more than 40 on the casual calculations. I have a 64 GB laptop, so that is going perfectly fine.
When the issue occurs, 1 report just keeps spinning and sits on "0%" CPU. It appears as if it is calculation, but when you try to interact, like scrolling through the list of query drawing in data, or pressing the save button, it won't allow you. But other reports may run perfectly fine parallel.
Usually I just finish the other reports, and then ctrl alt delete the report into closure. But that cause the recovered file to lose all data.
Hi DouweMeer ,
Could you please tell me do you have more than one Power BI desktop open and are editing multiple reports at the same time?
- Please had better do not open more than one report at a time to edit in Power BI Desktop. Opening multiple reports at the same time can cause slow operation
Is the data too large? What is your connection? How about trying to use Direct Query or Live connection? The report that has been spining is get a lot of data or connect to many the data sources?
- Please try to use performance analyzer to analyze the time consumption of each item.
- Optimize more complex calculated columns or measures.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
