Forum Discussion

NovaBI's avatar
NovaBI
Post Patron
6 years ago

Automated Snapshot / Bookmark

Hi everyone,   I am looking for a solution for the following issue:  I have an report that is refreshed on a daily basis from SAP. Everything is fine. But as the data implies one month and is dyn...
Need Help
NovaBI's avatar
NovaBI
Post Patron
6 years ago

Hi amitchandak ,

 

okay I will try to clarify it in a better way. I will put it simpler and just explain it on one visual.

 

We have a progression visual (clustered column chart) showing data until workday 19. Now lets say the last friday in a month is workday 20 and is created on the last saturday in a month. All calculations are done in SAP itself, nothing to do with BI.

 

But the data output is always centred around the current month. So if its now June, the refresh will "kill" the may data and show June, starting with Workday 1 again. And that is why i need a snapshot/bookmark of the data form the last month. Because people want to see the final numbers in BI.  I don't have the chance to get a period pearameter right now, so no slicers are   reasonable.

 

Last week:

 

current update:

 

 

So I need a automated snapshot in the last week of the month on the weekend or a bookmark people can refer to.

 

Otherwise they will say "where is my final data?"

  • NovaBI's avatar
    NovaBI
    Post Patron
    6 years ago

    Hi amitchandak ,

     

    thanks for the link, I already found that. I'm afraid that there is too much shortfall with that workaround, and as it is written there it does not work in PBI Service what is mandatory for my users.

     

    If there's an premium capacity that I could use, the incremental refresh with a data snapshot is makable?

      • NovaBI's avatar
        NovaBI
        Post Patron
        6 years ago

        Hi V-lianl-msft ,

         

        thanks for the input.

         

        I checked the incremental refresh, it is a nice feature but has precondition that makes it hard for me to use it.

        As we need a StartRange and EndRange formatted as Date-typ, my data does not imply that. I could create a "fake" date column with the SAP output that is in a weekly logic but not a true date.  But it is not worth the effort right now. Was just a sidequest I tried to solve.

         

        Thanks for the help anyways!