Forum Discussion
Dataset refresh running slow than dataflow
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!
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?
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.
2 Replies
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?
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.