Saving and using data that becomes archived.

Question

Hello,&nbsp; &nbsp; &nbsp; &nbsp; I has been requested that one of my reports add a function to show the average value of data on a slicer that would ideally contain at least a years worth of data. Unfortunately the data source is archived after 3 months and the data is changed to 0. Is there any way to have imported data saved so that when the data is refreshed the previous values are not replaced with 0?Thanks!

amitchandak · Accepted Answer

jh34620 , you can check this DAX append technique 
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/https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

Forum Discussion

Saving and using data that becomes archived.

1 Reply

Related content

Will archived PBIX files still open after PBIR becomes the only supported format?

How to Become a Power BI Partner

Lakehouse Files archival

Incremental Refresh – Archived Partition Overwritten After Refresh

Data Archiving