Can you add refresh time in a column of your data so you have snapshot reporting

[rpinxt]

Here is the use case:

So hourly (during a period every 30 min) we run a report and log some number.

I can easily make a report that gets the data but of course that data would get overwritten every time I refresh it.

Does Power BI have a solution for something like that. Is there a way I could have a refreshed time column in my dataset which makes it possible to see the status at these refresh times?

[rpinxt]

Yes thanks. Was afraid that this option was not possible.

We are already doing this and saving our "snapshots" in an excel template.

But of course this is not ideal because of the manual work.

[Anonymous · Accepted solution]

HI @rpinxt,

AFAIK, current power bi does not include any historically data analysis feature.

For this scenario, I think you need to back up your records to a temp data source with custom field that stores the backup datetime, then you can use power bi to get data from that data source with correspond timestamps for further analysis.

Regards,

Xiaoxin Sheng