Forum Discussion
Extremely Slow Refresh in PowerBI Desktop - Dataflow sources
Hello Community, I have been experiencing really slow refresh in Power BI desktop with all my sources coming exclusively Dataflows in Power BI Service. Taking more than 3 hours in one table only....
Hi AndresPesca ,
Base on your description, it seems like the report refresh is very slow in Power BI Desktop. However, it will be faster when published it to Service. And you've already taken substantial steps to troubleshoot the issue, which is great. In order to make further troubleshooting, could you please provide the following info?
- What's the version of your Power BI Desktop?
- Is there any background processes on your computer that could be consuming the resources running when you refresh the report in Power BI Desktop at the same time?
- Is there any update or refresh on that dataflow?
Best Regards
Hello,
Thanks for your repply and for your help. Find my answer below in blue.
- What's the version of your Power BI Desktop2.130.930.0 64-bit
- Is there any background processes on your computer that could be consuming the resources running when you refresh the report in Power BI Desktop at the same time?Due to company security I'm connected to internet throug a VPN (Zscaler), however in partnership with IT team we have check the issue with and without VPN connection with same results.
- Is there any update or refresh on that dataflow?I scheduled all source data flows to be updated at 1:00AM, and the issue is detecting during the day.
Hi AndresPesca ,
The version of your Power BI Desktop is the latest one. As the description in your original post, it seems like the dataflow only include one table. Could you please provide the following info for that dataflow?
- Is there a significant amount of data being processed?
- If it exist complex transformations or joins in your dataflows?
Understand and optimize dataflows refresh - Power BI | Microsoft Learn
Best Regards