Forum Discussion
Help with incremental refresh dataflow and dataset
Hi everyone,
I'm doing a job that I have a lot of dataflow with some big tables. I already did the incremental refresh in these big tables.
Do I need to do the incremental refresh again in the desktop to create the dataset or just in the dataflow is enough? Basically, do I need to do the incremental refresh in dataflow and also in my model in pbix?
Thank you
Hi hama21
Datasets referencing dataflows should not use incremental refresh . Refreshes to dataflows are generally performant, so incremental refreshes shouldn't be necessary .
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.
So if you configure incremental refresh for dataflow , you don't need do the incremental refresh again in the desktop .
Best Regards,
Community Support Team _ Ailsa Tao
1 Reply
Hi hama21
Datasets referencing dataflows should not use incremental refresh . Refreshes to dataflows are generally performant, so incremental refreshes shouldn't be necessary .
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.
So if you configure incremental refresh for dataflow , you don't need do the incremental refresh again in the desktop .
Best Regards,
Community Support Team _ Ailsa Tao