Forum Discussion
How to create last 5 day rolling line graph, without date column?
Hi Rutu_28
Power BI captures only the current state of the data at refresh time and does not retain historical versions. To keep snapshots, a Power Automate flow can be scheduled to run a query against the Power BI dataset (optionally adding a Today column and including it in the query), save the results as a CSV file in a SharePoint folder with a timestamp in the filename, and then use that SharePoint folder as the data source. The flow should be scheduled to run after the semantic model refresh has completed, based on an estimated refresh window. Note: you wiill need to convert the timestamp to your local timezone if your timezone isnt UTC.
Try this:
https://www.matthewdevaney.com/power-automate-run-a-query-against-a-power-bi-dataset/
Super UserHi Rutu_28 ,
Power BI is a Data Analytics & Visualization tool. The Ask that you have here to create a snapshot table / to have historic data maintained is not directly possible inside Power BI even if you have a date column. But anyway you don't have a date column too.
In case you have a date column, you can create a snapshot table that can be stored in an external storage that can then be imported into Power BI
Snapshot table can be created by loading this data that you have on a daily basis to another table in an external storage with the current date information it runs with. That way with every day you will start having the snapshots maintained in the source
Regards,