Forum Discussion

dgwilson's avatar
dgwilson
Resolver III
7 years ago
Solved

Incremental Refresh and a Merged Query

I have Financial Year 2019 data (currently at 19 million rows of data and growing). The idea is to refresh this data via Incremental refresh (and as far as I can tell that's working) out of the oracl...
Need Help
  • dgwilson's avatar
    dgwilson
    7 years ago

    This issue may be solved. To be confirmed.

     

    I have added the RangeStart and RangeEnd parameters to te FY18 table - so they are across two tables now.

    And I have right clicked on the FY18 table and also added the incremental refresh specification to that table as well - previously it was only on the FY19+ table.

     

    Initial refresh test has been successful.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi dgwilson 

I can't reproduce your problem, could you show more details so that i can reproduce this problem?

 

Please check this article, let me know how you configure the parameter “RangeStart” and  “RangeEnd”,

also rows storage policy and rows refresh policy in the Incremental Refresh window.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.