Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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.
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.