Adding a Row with "Snapshot" of current data every Friday

[nhtlr97]

Hello all,

I have been researching and unable to find a way to do this, but feel free to link solutions if I've missed any!

I have data coming from an API that is updated and overwritten every 5 minutes. I have analytics, graphs, calculations, etc based off this data. I do not have historical data, but I need to take a "snapshot" of current data (total devices online, offline, installed, etc) every Friday so I can use this data for an on-going line graph showing progress of installations and such for Project leads.

I was hoping to use dax formula to build a new table, and then if current day = friday, add new row to table with "Date, Online, Offline, Installed" placed statically. And then I could just point my graph to that new table to see data overtime moving forward.

[v-shex-msft]

HI @nhtlr97,

AFAIK, current power bi does not include to cache historical data features. You may need to use external tools to get data and backup history records.
Then you can use power bi to get data from the raw datasource and the backup datasource to do historical data analysis.

Regards,

Xiaoxin Sheng

[Hariharan_R]

Hi @nhtlr97 

   Power BI changes your table data whenever do you refresh. if there is change in the source table those changes only will be available in Power BI. It will not store the previous data (snapshot).

You need to build a custom logic to take the snapshot of the data and store it and then use it in Power BI again.

Ref- https://radacad.com/scheduled-snapshot-of-the-power-bi-data-and-report

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin