Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Problem refresh incremental Connexion SAP Hana for Reference, Append and Merge Query

Hello,

 

I have an incremental refresh problem in powerBI for SAP Hana connection, the incremental refresh works for the source table, but for the reference table and append table, the incremental refresh doesn't work, how can I make the incremental refresh for the reference table and appendix table work on powerBI?

 

Thanks,

Need Help
Tips and Tricks
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous,

     

    i think you have to filter the original query to reduce the data from hana

    and the appred query to control the storage of the historical data.

     

15 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Commenting to get more information on this as I will be playing with this concept in the near future.

     

    When you amnnually refresh the reference and append tables does it pull in the new data?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Hello Tad17
       
      In desktop, we have the data filtered according to the parameters, but after publication, the refresh in append, reference and merge query it just takes incremental refresh the data of a month of the source query, not all the history,
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hey Anonymous 

         

        I believe you may have to have the incremental refresh enabled for the reference as well. Check out this link: https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

         

        My other theory based on the threads from when the preview of incremental refresh was released is that since the historical data is stored differently in the original query after the incremental refresh the referenced tabled does not "see" the historical data when referencing the original query. Enabling Incremental refresh on the reference query (and others) should solve this, but I don't have the ability to test this yet and there isn't clear documentation on this problem. The alternative is to duplicate the original query instead of referencing it, make the necessary changes, and set up incrememntal refresh for the duplicate.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Could you show your queries of your reference table and append table?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hii,

       

      here are the queries, Original source table + two reference table + appendi

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Hi Anonymous ,

         

        i think it works this way.

        You have to insert the filter parameters in the "original" query and in the "final" query.

        In the "original" query, so that the data can be filtered in the source by query folding.

        In the "final" query, so that the parameterization is activated and the result of this query is saved.

        I assume that the parameter of the "final" query will be forwarded to the "original" subquery.