Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Full Refresh on Incremental Refresh data source

Hi, I have a dashboard that utilises multiple data sources. The biggest of which is "datasource 1" by a country mile. Currently "datasource 1" is set up to do an incremental refresh where it ...

Need Help

V-lianl-msft
4 years ago
Hi Anonymous ,

Full refresh will send a query to the database to return ALL EXISTING ROWS of data from the previous query as well as the new rows.

An incremental refresh will feed in ONLY NEW data in the dataset.

If you want to keep the old data and refresh the new data, incremental refresh can do it, please refer to:

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.