Forum Discussion
basic Question on Incremental refresh
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.
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
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.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 .
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.