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 tabl...
Need Help
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution 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