Skip to main content

Power BI

Needs Votes

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

Vote (1309) Share
Scott Sugar's profile image

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 (97)
Scott Sugar's profile image Profile Picture

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.

Scott Sugar's profile image Profile Picture

Marcelo on 06 Jul 2020 00:00:15

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

This would be extremely helpful feature to do over time KPI behavior analysis, great to have for sure.

Scott Sugar's profile image Profile Picture

Mircea Pacleanu on 06 Jul 2020 00:00:05

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

This feature would be great to have in PowerBi. Maybe the ability to create a static table to report off

Scott Sugar's profile image Profile Picture

Power BI User on 06 Jul 2020 00:00:02

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

This is an essential feature for some of our reporting and an industry standard in some other products. The sooner we can have this, the better.

Scott Sugar's profile image Profile Picture

Power BI User on 05 Jul 2020 23:56:02

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

Please add this to preserve the historical data or add ability to export data as csv on schedule

Scott Sugar's profile image Profile Picture

Power BI User on 05 Jul 2020 23:55:46

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

Yes please add the data snapshot feature!

Scott Sugar's profile image Profile Picture

Power BI User on 05 Jul 2020 23:52:49

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

Really need this feature

Scott Sugar's profile image Profile Picture

Gabriel Assuncao on 05 Jul 2020 23:52:17

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

This would be extremely helpful for many companies

Scott Sugar's profile image Profile Picture

AG on 05 Jul 2020 23:52:05

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

'+1

Scott Sugar's profile image Profile Picture

Aimee Ferguson on 05 Jul 2020 23:48:10

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

i.e. Need a comparison of today's data with the same data from 3 months ago. On a daily basis but should be able to roll up into weekly, monthly, quarterly, and yearly.

Merged Idea (5)