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

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

elijudy1 — Thu, 08 Sep 2022 21:56:14 GMT

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?

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

Anonymous — Fri, 09 Sep 2022 08:18:21 GMT

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

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

elijudy1 — Fri, 09 Sep 2022 09:30:08 GMT

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?

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

MarkLaf — Fri, 09 Sep 2022 21:11:37 GMT

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/