Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

basic Question on Incremental refresh

Hi,

I have one basic question on Incremental refresh. I have one table in my Power bi model and have other table(refrenced and duplicate) derived from this table. I have set up incremental refresh for this table but do I need to implement incremental refresh for other tables as well?? I am not seeing updated data from other derived tables.

8 Replies

  • Anonymous , if you have done copy paste and duplicated it, I think you might have to set up it for those tables

    • Anonymous's avatar
      Anonymous
      Not applicable

      what do you mean by copy paste? there is option to create a duplicate table and refrence table by right clicking on your table in the query and selecting duplicate or refrence.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, Anonymous ;

    Yes, if your Report or Dashboard uses data from other tables, you need to set incremental refreshes for other tables as well.

    You can set up the incremental refresh for multiple tables. You don’t need more parameters, the two parameters of RangeStart and RangeEnd are enough. You just need to set up the filter in any other tables you want as well.

     

    here is the incremental refresh's steps, 

    https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

    Best Regards,
    Community Support Team_ Yalan Wu
    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

      v-yalanwu-msft just to make it more clear to my question:

      my report has table A and I created a duplicate of table A and named it as table B. now I have implemented incremental refresh on table A, do I need to set up incremental refresh on table B as well??, thats my question

      • v-yalanwu-msft's avatar
        v-yalanwu-msft
        Community Support

        hi, Anonymous ;

        If your report uses the data of tableA, you only need to set incremental refresh for A, and the copied table B does not need to set incremental refresh.

        Best Regards,
        Community Support Team_ Yalan Wu
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.