Forum Discussion
Power BI file slow / crashing
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.
Super UserDoes it crash when you remove all measures?
Are you saying that you use 45 Power Query queries and then combining them into one report query? If so, please consider not doing that, but instead use the Folder connector and let Power Query combine the files for you (assuming they all have the same structure and you collect the data from the same place in each file)
Are your Excel files .xlsb or .xlsx ?
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.