Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
84 | |
84 | |
72 | |
49 |
User | Count |
---|---|
143 | |
131 | |
109 | |
64 | |
55 |