Dataset refresh running slow than dataflow

[PowerBI123456]

Hi - I have a dataflow that refreshes in 6-7 minutes, it's set on incremental refresh which is working fine. But I have a dataset connnected to it and it takes over an hour to refresh. I wouldn't think it would take that long, any one know why it does that?

Thanks!

[GilbertQ · Accepted solution]

Hi @PowerBI123456 

To me your dataset is not doing an incremental refresh, but is importing the entire dataflow each time it gets refreshed.

I would also configure incremental refresh on your dataset?

[v-robertq-msft · Accepted solution]

Hi, @PowerBI123456 

According to your description, I think the first thing you should keep in mind is that when you get data from dataflow using Power BI Desktop, you are getting the data that is already transformed and stored in Azure data lake storage of Power BI dataflows. So the incremental refresh will no longer happen if you refresh the dataset.

Here’s a document about how to use dataflow to make the refresh of Power BI faster, you can also take a look:

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

Best Regards,

Community Support Team _Robert Qin

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

[GilbertQ · Accepted solution]

Hi @PowerBI123456 

To me your dataset is not doing an incremental refresh, but is importing the entire dataflow each time it gets refreshed.

I would also configure incremental refresh on your dataset?