Incremental refresh length

[asadfje]

Why is the total time ~16min when data retrieval and query cache is only 3min+?

Happens for all refreshes not just first load.

For a few thousand data a day, totalling to about 80k rows now.

[Anonymous]

Thank you rajendraongole1 

Hi, @asadfje 

Heavy use of dashboard tiles or premium caching can increase refresh duration, as both can queue many queries after each refresh. The data and query cache phases are independent of each other, but run sequentially. The data refresh runs first, and after it succeeds, the query cache refresh runs. If the data refresh fails, the query refresh is not started.

Data – Load data into the semantic model.
Query Cache – Advanced query caching and/or dashboard tile refresh.

Dataset Refresh History Enhancements | Microsoft Power BI Blog | Microsoft Power BI

Best Regards

Jianpeng Li

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

[rajendraongole1]

Hi @asadfje - The total refresh time (~16 minutes) and the actual data retrieval time (3 minutes and 32 seconds, as shown in the image)

you can check on the following details:

you can review your Power Query steps for performance bottlenecks. Optimize where possible (e.g., by reducing steps or performing transformations at the data source).

In data modelling, check the calculations are optimized and avoid overusing calculated columns or tables.

cross verify and monitor dataset size in Power BI Service and evaluate if further optimization is needed (e.g., aggregations or partitioning).

In power query editor, verify that your queries support query folding by right-clicking steps in Power Query and ensuring "View Native Query" is available.

Hope the above steps will helps you to resolve the same.