Forum Discussion

elijudy1's avatar
elijudy1
Frequent Visitor
3 years ago
Solved

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

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 ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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