Forum Discussion
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...
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
I guess you can export the data to an excel file in sharepoint with flow (automatically) before refreshing the dataset, and you can re-import the data from that excel to Power BI and set to compare with the latest data.