PowerBI Service Slow Refresh

[Anonymous]

I was working with a dataset in powerBI that kept timing out when I tried to refresh it in service. The pbi file was only 322 mb, so I was stumped as to what this issue was. It turns out that a sort operation was slowing down my refresh by over 2 hours. What is the exact issue behind this because I havent run into this issue before.

[Anonymous]

Hi,

Thanks for the solution @lbendlin  provided, and i want to offer some more information for user to refer to.

hello @Anonymous , based on your description, you can consider to remove the ranking, and please check  that if you have complex calculation logic, you can refer to the following link to improve the refresh performance.

Optimization guide for Power BI - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Is the sort action really necessary? it may require the whole table to be loaded , and may break query folding.