Forum Discussion
PowerBI Service Slow Refresh
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.
Is the sort action really necessary? it may require the whole table to be loaded , and may break query folding.
2 Replies
Is the sort action really necessary? it may require the whole table to be loaded , and may break query folding.
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.