Forum Discussion
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 refreshes the last months data and keeps anything before that unchanged.
However, it has come to my attention that there are instances where a historic record may be added (vert rarely) to "data source 1" thus requiring a full refresh upon request. I can do this on the desktop file and republish however this significantly bloats the file size. Is there a way I can do a full refresh of this data source only upon request on Power BI online?
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:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Since this is not getting any replies. A solution that could work for me is:
Can we setup incremental refresh to only add new data but keep all existing data? Regardless of the date the data was created.
For example, I refresh the data on the 9th of March, there are 3 new records dating 1st of Jan, 1st of Feb 2022 and 5 feb 2021. I just need these 3 new records to be added.
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:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.