Forum Discussion
Power BI file slow / crashing
- 5 years ago
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.
HI AVIE,
How did you merge these query tables? Can you please explain more about these?
How to Get Your Question Answered Quickly
BTW, have you used multiple iterator functions in your expressions? They may also affect the performance.
Optimizing nested iterators in DAX
Regards,
Xiaoxin Sheng
- AVIE5 years agoFrequent Visitor
Hi,
My own solution I mentioned below resolved the problem so no need to look into this anymore!
Thank you!