Check when a particular field changes

[Brotedo]

I have a table of quotes from a SQL server that have a creation date and a status, but not a timestamp for status changes. I need that timestamp.

Here was my first thought. Pull in 2 versions of the table from the server and stagger the refreshes (refresh one in the morning, one in the evening), and have a third table with a calculated column doing something like this: if the quote IDs and status fields in the two tables match, blank(), otherwise, if the quote IDs match but the status fields do not, now(). That should give an approximate timestamp for the update.

Is there a better way to do this? Is there even a way to automate staggered refreshes for specific tables in PowerBI?

[edhans]

You'd have to set up a custom connector and use the REST API with PowerShell to stagger the refreshes of tables, or do it manually. You should really do that work in SQL Server. Power BI is not designed to actually generate data like you are doing, and a full refresh will reset both refresh dates to the same, wiping out the desired info.

Work with your DBA. They can set up a stored procedure to add the timestamps to the tables, then you just refresh your report.