Hi @Anonymous ,
When the refresh is in fact slow or crash, it can be due to several reasons:
- Insufficient CPU (refresh can be very CPU-intensive).
- Insufficient memory, resulting in refresh pausing (which requires the refresh to start over when conditions are favorable to recommence).
- Non-capacity reasons, including data source system responsiveness, network latency, invalid permissions or gateway throughput. You may increase the capacity for workspaces to increase the model refresh parallelism frequency.
- Data volume - a good reason to configure incremental refresh, Incremental refresh can significantly reduce data refresh duration, especially for large model tables. See more: Incremental refresh in Power BI Premium .
See more details: https://docs.microsoft.com/en-us/power-bi/service-premium-capacity-optimize#why-are-refreshes-slow.
When you refresh data in Power BI Desktop, there may be other applications to consume CPU or memory, so it may refresh slow in Power BI Desktop compared with in VM.
You may try to improve the performance for the data model, see Power BI performance best practices , Power BI Performance Tips and Techniques.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
