Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
We have incremental refresh on our dataflows where several dataset is pulling from.
Some of the dataset is quit large and I'm considering using incremental refresh on the dataset aswell.
I wondering if there any downside/upside using incremental refresh on a dataflow that allready have incremental refresh?
Hi @msundelius ,
With dataflows, you can bring large amounts of data into Power BI or your organization's provided storage. In some cases, however, it's not practical to update a full copy of source data in each refresh. A good alternative is incremental refresh, which provides the following benefits for dataflows:
Notice: Using incremental refresh in dataflows created in Power BI requires that the dataflow reside in a workspace in Premium capacity.
For more information,please see:Using incremental refresh with dataflows
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I mainly wondering if there is any problems doing the incremental refresh when the source is dataflow.
Hi @msundelius ,
What is the problem you are referring to, I may not understand very well.
Dataflow incremental refresh and dataset incremental refresh are designed to work in tandem. It's acceptable and supported to have an incrementally refreshing entity in a dataflow, fully loaded into a dataset, or a fully loaded entity in a dataflow incrementally loaded to a dataset.
Both approaches work according to your specified definitions in the refresh settings.
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @msundelius
I would recommend doing it, the incremental refresh makes everything a lot quicker to process. And who does not like things happening quicker?