Forum Discussion
To build a table with a historical data.
Hi,
I have a data source, but always that there is a change on this data, it don´t keep the last data.
My data sorce has always the data on moment.
I need to keep the historical data to analyse data and build the reports.
I have a table A with data of data source. To save the historical data I am thinking to create a table B and always the Power BI is updated the table B save the data of table A.
Is it possible to do using languagem M? How?
Thanks
You can read this blog about it, but I do not recommend this in a production environment. It is an interesting side effect of how Incremental Refresh works, and unless you get comfortable editing partitions and using the ALM toolkit, any time you publish a revised report your old data will get deleted.
Power BI is designed as a "Wipe everything, refresh everything" model. Best practice is come up with a process where you can store archival data and then use the Combine feature in Power BI to have multiple versions of data to compare with Anonymous
1 Reply
You can read this blog about it, but I do not recommend this in a production environment. It is an interesting side effect of how Incremental Refresh works, and unless you get comfortable editing partitions and using the ALM toolkit, any time you publish a revised report your old data will get deleted.
Power BI is designed as a "Wipe everything, refresh everything" model. Best practice is come up with a process where you can store archival data and then use the Combine feature in Power BI to have multiple versions of data to compare with Anonymous