Forum Discussion
How do I write my dynamic query results into a static table inside PBI desktop
Dynamic Table changes date value daily
The above is a dynamic table that changes "Date" values once daily. I need this data to append to the #"Daily Chart Count" table daily without it overwriting any of the existing data. How do I do this?
Hi elijudy1,
AFAIK, the current power bi does not include any historical analysis features to cache the history data.
You need to back up these daily records to the external data source then you can use power bi to get data from these cached records.Regards,
Xiaoxin Sheng
3 Replies
Hi elijudy1,
AFAIK, the current power bi does not include any historical analysis features to cache the history data.
You need to back up these daily records to the external data source then you can use power bi to get data from these cached records.Regards,
Xiaoxin Sheng
Does power bi have the ability to auto-write (like, for example, using Power Automate) to an external data source, and what sort of external data sources might you have in mind?
You can achieve this with incremental refresh. It's a bit hacky and should probably be used only if alternatives aren't available. A good article on doing this can be found here: 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/
