Forum Discussion

RichA08's avatar
RichA08
Frequent Visitor
10 months ago
Solved

Can I Save Data Before it Refreshes?

Hi All,    My data refreshes daily and I need to compare it to the previous day. I cannot do incremental refresh as it is not done by date. The data deals in forecasting so it has future dates in i...
Need Help
  • samratpbi's avatar
    samratpbi
    10 months ago

    Hi, it is better to handle this type of scenario in backend itself. May be you can create a snapshot table, which will keep previous day's instance in another table before the data refresh. For every date, you may append into your snapshot table and keep track of your your history data accordingly.

     

    If this helps to resolve your problem then please mark it as solution.

    Thanks - Samrat

danextian's avatar
danextian
Icon for Super User rankSuper User
10 months ago

Hi RichA08 

 

Power BI doesn't store a historical copy of the data so this must be stored somewhere else - an excel file, a database, etc. It reads  whatever is in the datasource upon refresh and overrides the previously existing data. If you are on Fabric, as already mentioned by other users, you may use Dataflow Gen2 instead to pre-process your data instead of doing it in Power Query in Power BI as it has an option to append instead of simply to overwrite.