Forum Discussion
PowerBI Desktop Freezes [Not Responding]
Dear PowerBI Team,
I build a model with couple of tables with importing from Excel Files, few joins, few calculated tables and lots of calculated functions. All of a sudden the model has stopped workings. Whenever I am trying to open the file in Desktop it freezes with Not Responding. Can you please advice, I will hate to rebuild the entire model once again from the scratch.
Thanks,
Sami
21 Replies
Hi all. I worked with the Microsodt tech support team on the issues I was having with my file. My issue was because of the resizing of a calculated tables and it had a scroll bar both horizontally and vertically. They determined that the issue with my tables was entering an infinite loop when the table visual is a certain size with a scrollbar. They said for the next release of the Power BI Desktop, there will be a fix applied to that version but not sure of the ETA yet. Hope this information helps.
Count me in as well. What's worse, I had done a couple of hours of work and when I made a change to a visual it locked up. I should have been able to just kill the session and re-open the file to it's previously saved state; which did not have the issue. Sadly, it is now stuck on whatever caused the problem and I have to recreate the file from scratch.
There should be a switch or function to open the pbix without calculating so one can delete the problem visualization.
Same issue for me and hoping for fix soon. Is there any way to remove the visual in the file causing the problem?
I use a 16gb ram Laptop and I still experience these issues most especially when I am using query editor.. my data source is SharePoint online list at every point in time it freezes over everything done import, edit, measures, append and everything you can do with the editor and this has greatly affected my turn around time.
I used to encounter lots of performance issues around importing data and folders from SharePoint Online, until I undertook a major optimisation of my Power Query code. I tried to minimise the number of query steps that were generating a refresh of data back to SharePoint. I found that the biggest improvement came from buffering the SharePoint data at the point of pulling the data from SharePoint, like this:
RET =
Table.Buffer(
Table.RenameColumns(
Table.SelectRows(
SharePoint.Files(
"https://" & TENANT_NAME & ".sharepoint.com/",
[ApiVersion = 15]
),
each(
// RET
[Name] = RET_FILE and
Text.Contains([Folder Path], RET_PATH)
)
),
{{"Folder Path", "FolderPath"}}
)
),Since doing this I've had no issues with SharePoint Online performance.
neatdot please can you do screen on how to insert this code and where to insert them thanks.
Similar issue here. Added two matrix tables, published them and now the desktop software freezes when opening the file.
Same thing is happening to me as well. Rebuilt, tried to copya tab and the original tab hangs and the file is not responding. I close out, try to reopen and software freezes. Please help!!
Sorry for the very late reply. Can you send your .pbix file? Or, does it still reproduce with the latest version of the product?
The issue started happening with the latest version. I'm on Version: 2.29.4217.341. Thanks!
Same issue here!
Same issue for me. Rest of the model continues to work and update, just one tab - of course the one with most time spent on! Version: 2.29.4217.341
I have just published the model and all works OK!
I have been having the same experience. I'll watch my perf monitor and PBI will end up consuming my 8GB of Ram and will have to exit and re-enter. I've removed the matrix table and will see if that was the cause.
I see that this thread started 3 years ago. Still not allright. I have encountered the 'freeze' issue too many times.
Would have been nice to know why it is happening. A error message while reopening the recovered file would have helped.
Now for me, this happens for the same field and the same data set and is not when a maneuver is done.
I have multiple slicers on the page. I select one It is fine. I select another, it froze. I saw that it was not random and it was the same value being chosen on the slicer that would freeze Power BI. What could be the issue.
I had this issue for the first time today, I got around it by clicking the arrow in the top right of the GUI beneath the Close icon (^).
I clicked this twice, it hides the frozen ribbon then reopens it and upon reopening it was fully functional with all buttons displaying tooltip and the functionality returned.
Yes, it's still happening! :-(
