Forum Discussion
Improve refresh times (Avoid timeout error)
Hi everyone, For the past couple weeks we are running into a timeout error for a specific dataset in our premium workspace. It does not happen everyday, but the frequency of the error is increasi...
It can be reallly challenging to understand what portion of a Dataset refresh is causing slowness. I've relied heavliy on the method described in this blog post to analyze my refresh and pinpoint bottlenecks.
https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/
Also, using the "Best Practice Analyzer" in Tabular Editor is incredibly helpful at guiding you (and helping you fix) inefficiencies in your datasets.
https://www.sqlbi.com/tools/tabular-editor/
I've been able to reduce model sizes by half (!) and reduce refresh times by more than half (!) just by using the two tools above.
Thanks a lot! I will review this and see what I find 🙂