basic Question on Incremental refresh

[Anonymous]

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.

[v-yalanwu-msft]

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]

@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]

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.

[Anonymous]

@v-yalanwu-msft I fear you are wrong or I hv just discovered a bug in here.

1. take a table( I am connected to Azure table storage in my case) and then create a refrence table by clicking on it.

2. have two page in your report one with main table data and other page with refrence table data only.

3. now impement your incremental refresh in main table and do a refresh in Power bi service after publishing. You will see result only on first page and not on other . 

[v-yalanwu-msft]

Hi, @Anonymous ;

As I said above, if your Report or Dashboard uses data from B tables, you need to set incremental refreshes for B table as well.
In summary, if you want to refresh a report, then you need to set an incremental refresh for the table used in that report;
You mentioned "other page with refrence table data" here, so if you want to refresh the second page, you also need to set an incremental refresh for the B table.

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]

You said copied table B need not set up incremental refresh. I metioned that I was using both the table and one table is refrenced from another table

[amitchandak]

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

[Anonymous]

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.