Refresh from Dataflow slow

[joshua1990]

Hi all!

I have a dataset that gets a lot of data via Dataflow.

This dataflow contains the weekly sales and gets appended every week.

Now, the refresh takes a huge time from this dataflow.

Is there any way to optimize this? What I understood is that incremenal refresh does not work here, correct?

What can I do to optimize the refresh time?

[rajendraongole1 · Accepted solution]

Hi @joshua1990 - Incremental refresh, if applicable, is one of the most effective ways to reduce refresh times, along with query optimization and data reduction strategies. Ensure that your Power BI workspace has Premium or Premium Per User capacity for the incremental refresh functionality in dataflows.

Understand and optimize dataflows refresh - Power BI | Microsoft Learn

https://radacad.com/how-to-use-dataflow-to-make-the-refresh-of-power-bi-solution-faster

hope this helps.