Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am utilizing Power BI Desktop linked to an AWS Redshift database for analytics purposes. My objective is to perform day-to-day comparative analyses on a particular data dimension to monitor changes over time. The primary challenge I face is that this dimension only displays the most current data without historical tracking. I am keen to automate the process of historical data capture within Power BI, particularly using the "Transform Data" module.
Specifically, my requirement is to automatically create a snapshot of the "Live" data dimension each day and preserve this as the "Yesterday Version," which would continuously update to reflect the data from the day immediately preceding the current one. This approach would facilitate direct comparisons between the "Yesterday Version" and the "Live" version each day.
Can you advise if Power BI provides the capability to automate this snapshot process natively, or if it requires custom scripting within the "Transform Data" module? Furthermore, if this task necessitates a workaround involving both Power BI and AWS Redshift, could you provide a comprehensive guide on how to implement this solution effectively, including any necessary scripts and scheduling tactics?
Solved! Go to Solution.
The only way I have seen people keep historical snapshots is to have that in their datawarehouse as a table.
Proud to be a Super User! | |
The only way I have seen people keep historical snapshots is to have that in their datawarehouse as a table.
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |