Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Incremental Referesh in Report Server

Dear community,  I need your help.  How can I set an incremental Refresh with power bi Desktop (reports server version January 2020) ?   I need to call a dataset for 12 months of data and keep th...
needhelp
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler Thank you for the reply. 

When I right-click on my table in the query editor, there is no "Incremental Refresh" on the menu. 

 

I even check the file>options>setting. There not an option there as well.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Anonymous - Hmmm, perhaps incremental refresh is not supported with Report Server, let me do some digging. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Greg_Deckler  in RADACAD it is written that it not supported, but the post is for last year June. 

       

      I was thinking maybe with the last Desktop version (January 2020) it will be added. But apparently not. I just need to make sure.

      If really Incremental Refresh is not supported in Report Server, this is a huge BUG !!!! 

      There are so many disappointments when it comes to report server, like not being able to pass the parameters to the dataset, like the way we did in the Report Builder. ğŸ™„

      • KBO's avatar
        KBO
        Memorable Member
        6 years ago

        Hi Anonymous ,

        I wouldn't say that this is a bug If you like to have a incremental refresh may be you switch to SSAS as datasource. With this you can do a incremental refresh but a little bit diffrent from the one in Power BI :).

         

        Best,

        Kathrin

         

         

         

         

        If this post has helped you, please give it a thumbs up!
        Did I answer your question? Mark my post as a solution!