Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
A PowerBI report uses an imported semantic model.
The data source of the model is being refreshed on a daily basis.
The PowerBI report needs to create visuals with trends over time.
This requires a monthly snapshot of one of the tables (e.g. current table) in the imported semantic model.
The main objective is to create a new table (complete table) in the PowerBI with the same schema as the current table plus one attribute that will hold the YYYY-MM value. In the beginning of every month, the current table should be automatically appended at the complete table. By this way, the complete table will hold all current and historic data.
I would like to ask if this is possible to perform using the PowerBI desktop or any other tools in the same family suite.
Thanks in advance for your help.
Regards,
Akis
Solved! Go to Solution.
Hi @lafakios,
Power BI does not have any native option for taking snapshots of data at a given point of time. So you'll have to make use of some staging area or database where you can hold such data.
Generally, this is the capability of a data warehouse. For example, in our organization, we have a sophisticated data warehouse implementation which is being used for this purpose and a lot more.
Below are some of the solutions you can start thinking about for achieving your desired results -
So you now have a couple of ways to implement your desired solution and achieve your requirements. Implementing a Data Warehouse or proper external storage can have barriers, so I would recommend looking at the Power Automate solution more seriously.
Do let me know if you have any questions or need any help!
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
Hi @lafakios,
Power BI does not have any native option for taking snapshots of data at a given point of time. So you'll have to make use of some staging area or database where you can hold such data.
Generally, this is the capability of a data warehouse. For example, in our organization, we have a sophisticated data warehouse implementation which is being used for this purpose and a lot more.
Below are some of the solutions you can start thinking about for achieving your desired results -
So you now have a couple of ways to implement your desired solution and achieve your requirements. Implementing a Data Warehouse or proper external storage can have barriers, so I would recommend looking at the Power Automate solution more seriously.
Do let me know if you have any questions or need any help!
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
Power BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, there is the self referencing option but that has no safety net.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |