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

Anonymous's avatar
Anonymous
Not applicable
10 months ago

Hi RichA08  ,
Thanks for reaching out to the Microsoft fabric community forum.

A recommended approach is to use Fabric Dataflow Gen2. You can start by creating a dataflow that imports your source data (representing “Today”) and, in Power Query, add a timestamp column using the formula = DateTime.LocalNow(). This column will help you identify the refresh date for each snapshot. Save this dataflow as your “Raw Snapshot Loader” to a Lakehouse table. Next, Refresh the data in your dataflow the updated data should reach a new table in Lakehouse. Once set up, your Power BI dataset can connect to these Lakehouse tables and calculate yesterday-versus-today differences using DAX measures. This method is efficient because it keeps your data versioned within Fabric.


I hope this information helps. Please do let us know if you have any further queries.
Thank you