Forum Discussion
Power BI Desktop, import data from SQL Database and build a history
No. Power BI is a read only tool, it cannot change data in the source nor add an archive. Each refresh is a "wipe everything and reload from the source."
To create an archive of what was done, you would need to either use a Stored Procedure to append data to a history table you create when that table changes, or use Power Automate to do this via a flow. It can detect when records change and add data to a new SQL table or an Excel spreadsheet if that is easier.
No. Power BI is a read only tool, it cannot change data in the source nor add an archive. Each refresh is a "wipe everything and reload from the source."
To create an archive of what was done, you would need to either use a Stored Procedure to append data to a history table you create when that table changes, or use Power Automate to do this via a flow. It can detect when records change and add data to a new SQL table or an Excel spreadsheet if that is easier.
Thank you Ed Hans,
I will study the Power Automate and Flow possibilities to create a new table or spreadsheet.
Kind Regards,
Björn
