Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

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

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

    Frank on 06 Jul 2020 00:13:31

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

    Please add... !! It will be important, useful and for anyone really helpful! Thanks and cheers!

    Scott Sugar's profile image Profile Picture

    Manfred on 06 Jul 2020 00:13:30

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

    please add this feature, it's really important for us!

    Scott Sugar's profile image Profile Picture

    Glen on 06 Jul 2020 00:12:13

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

    Absolutely a requirement. Leadership needs to see month-over-month trends, but data that is updated daily makes me have to manually capture and build this. My goal is seomthing like this: My PowerBI looks at today's data & does a bunch of work to get a KPI (say, a count of something), and automatically stores that result with a datestamp. Over time I can show trends of those results.

    Scott Sugar's profile image Profile Picture

    K. H. on 06 Jul 2020 00:09:56

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

    I would specifically like to see this in PBIRS. This is a common request from stakeholders that we could deliver more quickly than having lobby for developer resources to implement for each data source.

    Scott Sugar's profile image Profile Picture

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

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

    i would use this in hundreds of reports

    Scott Sugar's profile image Profile Picture

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

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

    Indeed a very helpful feature I'm surprised to learn is still not available...

    Scott Sugar's profile image Profile Picture

    Dustin Baker on 06 Jul 2020 00:06:16

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

    Upvoted, this would be a useful feature.

    Scott Sugar's profile image Profile Picture

    Kevin Mooney on 06 Jul 2020 00:05:45

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

    Yes please. This would make it easier to develop KPI bowling charts over time when the data is changing but has no timestamp.

    Scott Sugar's profile image Profile Picture

    Anand Patel on 06 Jul 2020 00:04:02

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

    Yes please add, essential to track measure

    Scott Sugar's profile image Profile Picture

    Brad DeRider on 06 Jul 2020 00:03:49

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

    Agree with the comments here. Snapshot reports/datasets are a fundamental part of a BI/BA tool. Without this being built-in, it is incredibly laborious on a PER-REPORT BASIS. One should not have to involve project and money requests on a PER-REPORT BASIS just to get snapshot cards. The entire point of business analytics, data analysis, and business intelligence is to enable self-service for content creators. Every type of dashboard I create has at least a few tracking/snapshot cards from the live views. Right now, this has to be put into flat files on a sharepoint (what?!?!?!) or involve IT to create a data source for EACH report I want snapshot/tracking card. When a card has twenty data points or some really small number

    Merged Idea (5)