Power BI Service Refreshes Taking Excessively Long

Hi amir_mm ,

When using data flows, especially with numerous transformations, the shared capacity model can impact performance. Unlike Power Query in desktop, which benefits from dedicated CPU and memory, dataflows share resources. This sharing can lead to slower refresh times. Consider reviewing your transformations and optimizing them where possible. Simplifying complex transformations or reducing the number of steps might help.You can read this topic for some helps: Solved: Data Flow Slow Refresh - Microsoft Fabric Community

Loading a model into memory during refresh requires memory resources. The size of your dataset impacts this process. Keep in mind that refreshing a model consumes approximately twice the size of the dataset in memory. If memory resources are scarce, it can lead to longer refresh times.

If multiple datasets refresh simultaneously, they compete for CPU and memory resources. Consider staggering the refresh schedules to avoid resource contention.

Finally, you can also review the refresh logs to identify which entities contribute to the longer refresh times.

Best Regards

Yilong Zhou

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