Skip to main content

    Power BI

    Needs Votes

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

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