Refresh Data with updates from SQL Server

[jjcollins1]

Hey all,

What I am trying to do is pull data from a SQL server and note changes in the data without deleting previous versions of the data. This is a library of software development requests that will go through a series of changes over time (first it needs business review, then it's in queue, in progress, etc.) What I would like to do is be able to set things up so that the data refreshes automatically at set intervals but keeps data on each request without deleting previous data. For example, every request that I have that is "Complete" currently only shows as complete. I would like to have the same request ID but have dates for when it was changed from in queue to in progress to complete. So several entries for each request with a corresponding date ONLY if the request has been updated. Is this possible? Thanks in advance!

[AlexisOlson]

Power BI is not designed to be a database where you store historical versions of data. It's a dynamic computation engine and visualization tool rather than a data storage tool and should not be relied on to store data that isn't recorded somewhere else.