Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (1250) 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

Egbert Power BI User on 19 Feb 2023 10:12:23

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

Gamechanger if we get this in place. We now use for some usecases dataflows for yearly snapshots but that is not dynamica enough for shorter timeframes

Scott Sugar's profile image Profile Picture

on 02 Nov 2022 23:38:15

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

Ability to store snapshot of report when data get refreshed.

- so if user want to backtrack and check previous report he is able to do that.

Scott Sugar's profile image Profile Picture

on 02 Nov 2022 23:37:02

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

Need the ability to snap what the report looked like at the beginning of each month. This can be done for Report Builder reports on the PowerBi server but not on the PowerBi reports on the server

Scott Sugar's profile image Profile Picture

on 02 Nov 2022 23:35:10

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

Be able to automatically schedule a data snapshot/export data on a weekly or monthly basis.

Scott Sugar's profile image Profile Picture

on 02 Nov 2022 23:31:04

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

Hi,

We receive a daily count of our patient numbers per location via Microsoft BI.

Unfortunately there is no way to view any data in history form.

Meaning that once todays numbers are produced in Microsoft BI, it automatically overwrites yesterdays information.

This makes it difficult to manage data usefully if you can only view current information and can not track history and trends.

Is there a way that the system can avoid overwriting the data, so that I can get the patient counts per site for any date in history that was previously published?

Thanks,

Sima


Scott Sugar's profile image Profile Picture

Kasper Bøgeskov on 28 Oct 2022 06:45:46

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

We really need this

Scott Sugar's profile image Profile Picture

Deborah Bell on 31 Aug 2022 16:43:06

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

We are currently saving copies of datasets each month for financials, and really need this functionality!

Scott Sugar's profile image Profile Picture

Shane Baker on 20 Jul 2022 01:05:14

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

Having this functionality in ServiceNow via its Performance Analytics feature is an absolute pleasure to work with. When I was presented with PowerBI, I thought it was horrendously under-powered without this function....

Scott Sugar's profile image Profile Picture

Allan Bakker on 18 Jul 2022 19:35:47

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

This feature would be great. There are many times where the data can be recalculated but we would also like to use the snap shot to track progress mid process if that makes sense. Eg. # of jobs with status pending. By the next update the status will have changed from pending to in progress or completed so being able to automatically keep track of snapshots would be amazing!


Scott Sugar's profile image Profile Picture

ISHAQ NAWAB on 22 Jun 2022 12:15:45

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

This function will be a huge help to a lot.

Merged Idea (5)