Forum Discussion
Append changed values to a query
Hi CarlsBerg999 ,
so you have to create a table where you can store historical data and automat the refresh of it on a daily basis.
Setting up a flow in Power Automate would be one option. You could fill a SP list or even write to a SQL DB with it.
Another option would be to setup a Dataverse/CDS dataflow (not Power BI !), as these allow appending new data. (Power BI dataflows will always overwrite).
Hi,
Power Automate could indeed provide a solution, but its not the most elegant. Could you clarify the incremental refresh for me, because this seems like a pretty standard thing and I dont understand what is the use of incremental refresh if it doesnt pick up the latest additions to a data set:
- If i have a column that indicates dates, wouldn't incremental refresh just append the existing queried data with the latest dates as determined? For example: If incremental refresh is set to 1 days, shouldnt it check everyday if there are new data entries with yesterday's date and add it to my data?
- I have set up two incremental refreshes in Power BI Service. Both have a 1 day interval incremental refresh set up in Power BI Desktop and then I uploaded them to Power BI Service. For the other one, i also set up a scheduled refresh every day at 8:00 am. Is the scheduled refresh required to set up with incremental refresh?
Im trying to grasp why the existing data is overwritten every time instead of appending it..