Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have a pbix file that pulls data from a couple of sources and brings together a mart table that i create a number of measures and visuals from.
I'd like to track this over time and the transactional data doesnt support this.
My idea is to create a snapshot of this table daily (ie freeze it in time with a datestamp on each row) and store it in a snapshot table, the following day/week/period etc the model would create another snapshot and add it to the snapshot table and repeat ad infinitum.
Is this possible in the data model? if so does anyone have any examples or ideas please?
(Ive had a team previously do this for me in sql in a data warehouse in a previous life but the company im working for at the moment are very resource light so its only a PowerBI model in the service at the moment)
No, there is no warehousing capability in Power BI. You would have to save the backups on the source side like you describe from your previous job.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |