Forum Discussion
Need help appending new rows to existing rows when refreshing with a date component
Hi Anonymous ,
Maybe the incremental refresh helps you. Please refer to
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
When performing an incremental refresh, the historical period is not refreshed, only the refresh period set in advance.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stepher,
I donn't think incremental refresh would work for my case because I do not have a date component or anything that I use to filter. For example, it would be like connecting to a folder that saves a copy of the dataset on a daily basis but with a single file. I want Power BI to take a snapshot of the data every day at one particular date and add the data to a master table with the date it was snapshotted. Lets say the data on Day 1 has 15 lines and data on Day 2 has 17 lines. The Master table would have the data from day 1 and day 2 with a total of 32 lines with a differentiator which would be the date of the snapshot.