Forum Discussion
INCREMENTAL REFRESH, MULTIPLE TABLES
I HAVE SEVERAL TABLES THAT COMBINE A FINAL TABLE, DTY1,DTY2, DTY3, ETC, THE FINAL TABLE ARE DTY FINAL (TABLE COMBINE).
THE FILTER FOR THE DATE (RANGES START AND RANGEEND) SHOULD BE IN ALL THE TABLES OR ONLY EN THE FINAL TABLE (TABLE COMBINE).
THANKS
No, you don’t need to set up incremental refresh on each table that goes into building your final table.
You only need to apply it on the final table the one you actually want to refresh with new data.
Additonally you can refer this doc : Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
Hope this helps !!
4 Replies
You question is unclear to me
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Sorry for the explanation.
The question is that if i have to put at incremental refresh in every table that build the final table (7 tables build the final table [with the combine table]
No, you don’t need to set up incremental refresh on each table that goes into building your final table.
You only need to apply it on the final table the one you actually want to refresh with new data.
Additonally you can refer this doc : Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
Hope this helps !!Hi CESARPULIDOGDL ,
Just checking in on your question regarding incremental refresh setup.
As mentioned earlier, you only need to enable incremental refresh on the final table the one you actually intend to refresh with new data not on every intermediate table.
Please let me know if you need any further clarification or assistance we’re happy to help!
