Forum Discussion
Solved
Power BI file slow / crashing
Hi, I have a Power BI file of a very small size (159 kB). It is built up via PowerQuery by loading +-45 different Excel files. All of these Excel files are also extremely small (+- 200 kB per f...
Dear lbendlin ,
Thank you for your response!
The sources are unstructured (I need to adapt them before being appendable) and all come from a different folder, so I don't think your solution will work? Or would it? They are all xlsx files.
The issue does not disappear when removing the measures.
I have unchecked the settings box to allow data previews to download in the background and it seems like it's running normally now... Not 100% sure yet whether it won't crash anymore, but it seems to work way better at least! So possibly this might have been the solution.
lbendlin
Super User
Super Useryou may also want to test to disable parallel loading of data sources, otherwise you risk overwhelming the file server.