Power BI

Needs Votes

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

Vote (621)

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 (67)

Comments (67)

31576b90 256b-4d97-adeb-211a470f7354 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.

b21e461c b1a7-440f-8195-784d7fb211e7 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.

c3c88dae 90a5-4c14-b939-1c068b462e1c 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

3d3af86e 6924-483a-ac8a-a09a2e090442 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.

682b4b32 0d0e-4c04-b473-92b42b4d9804 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

e60baa24 e6d4-40b9-9a49-9e19a2c50a5c on 05 Jul 2020 23:55:46

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

Yes please add the data snapshot feature!

d2ae87ea 0184-4165-a9c8-4a14a94491a4 on 05 Jul 2020 23:52:49

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

Really need this feature

038e153f 759c-43c9-a23f-2b7af3c56c9b 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

070828dc 49c1-4ab7-b1d6-3c67062796cd on 05 Jul 2020 23:52:05

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

'+1

f8644d50 dfbb-49e6-ae81-bb94cd77a954 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.