Forum Discussion
Incremental Refresh Policy in Dataflows and Datasets
Hi, friends! I am working with a big table (more than 100 million rows), and to increase the performance, I am configuring the incremental refresh. My structure is: - Data is extracted from a DB...
It just depends on what you need performance wise.
Incremental on a Dataflow reduces pressure on the Source, Power BI Service, and reduces Dataflow run time.
- If you then sourced that Dataflow in Desktop and made that Incremental too, you would reduce pressure on Power BI Service and Dataset refresh run time.
For me, Incremental refresh on Desktop is a absolute no-go because you lose the ability to download the Dataset from Service.
If your Dataset refresh time is acceptable to you, I wouldn't turn on incremental as it has downsides along with the upsides.