March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |