Help with incremental refresh dataflow and dataset

[hama21]

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

[Anonymous · Accepted solution]

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 .

https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-configure-consume#ref...

https://learn.microsoft.com/en-us/power-query/dataflows/incremental-refresh#dataflow-incremental-ref...

Best Regards,
Community Support Team _ Ailsa Tao