Power BI

Needs Votes

Allow for point-in-time snapshots for reports/dataset

Vote (1289)

Scott Sugar on 03 Feb 2016 15:04:38

datasets/reports only show latest data. Would like to be able to schedule each month to save a point-in-time snapshot of the report/dataset as it is at that time. Then I can show a client their report from this month, or last month, or one year ago. Not just the data as it is at the latest refresh

Comments (99)

Power BI User on 06 Jul 2020 00:03:14

RE: Allow for point-in-time snapshots for reports/dataset

Essential feature for tracking the movement of metrics over time where the data is not captured in the source data e.g. trend of customer count per energy tariff over time

M Rotta on 06 Jul 2020 00:02:09

RE: Allow for point-in-time snapshots for reports/dataset

Very useful. All the workarounds I've found are laborious and require manual data exports.

Paul Cooper on 06 Jul 2020 00:01:37

RE: Allow for point-in-time snapshots for reports/dataset

You don't just need the ability to have snapshot data sets but the ability to:

1) build reports on data across the snapshots. Such as plotting the change in a measure over time. Snapshot date would be important piece of metadata
2) Set Operations on snapshots. (Union, Union All, Intersect, Except, etc) This may apply to two or more snapshots together
3) Snapshot selection rules. E.g. The last snapshot plus the one on or just before the last snapshot date minus 1 year.