How do I write my dynamic query results into a static table inside PBI desktop

[elijudy1]

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?

[MarkLaf]

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-...

[elijudy1]

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?

[v-shex-msft · Accepted solution]

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