Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Save the data snapshot on Power BI

Hi,

 

I intend to save the snapshot of data in monthly refreshing. I am wondering if it's possible to save history data on power bi without using a database. My original idea was to create two tables, append the latest data to the history table, just like the insert operation in sql. However, I found each time I refresh data, all steps in a data source will be executed which means it refreshes from the "source". Thus, I can't accumulate data because there is no physical table. 

Could you please let me know if there is an alternative approach? Or this kind of manipulation can't be achieved with Power BI.

 

Thanks a lot!!!

 

Need Help

1 Reply

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    Yes. You can use Power Automate to query your dataset for the latest data and write that to a CSV on SharePoint (or other location) and name it with date. You can then use that folder of SharePoint files as the source for your report. You can do it all with a single dataset, but it cleaner to have two - the snapshot dataset you query and is not consumer facing, and the one that combines the SharePoint files.

     

    Pat