Incremental Refresh on a table that is not loaded but is included in report refresh

[baby_owell]

I haven't really tried this but looking for insight if this is possible. Problem is I have multiple sources that I need to apply incremental refresh, transform, then eventually merge. Instead of loading all the staging tables in between, I was thinking of only loading the resulting table (i.e. after transformation and merging) to minimize the data size for refresh.

I can only see the menu for incremental refresh if the table is loaded so I need assistance if there is a way I can apply incremental refresh on unloaded table.

[Shubham_rai955 · Accepted solution]

@baby_owell , Incremental refresh can only be applied to tables that are loaded into the data model; you cannot set up incremental refresh on a query with Enable Load turned off. For your scenario, stage all transformations and merging in Power Query, but make sure the final result table is loaded (enabled) in the model before applying incremental refresh. After setup, you can minimize model size by only loading the final merged table, intermediate tables can stay unloaded.

[v-venuppu]

Hi @baby_owell ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[v-venuppu]

Hi @baby_owell ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @baby_owell ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @MohamedFowzan1 @Shubham_rai955 for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[MohamedFowzan1 · Accepted solution]

Hi @baby_owell 
As you can see below in the reference only when loaded you will have the option to actually set up incremental refresh either any single table or the final merged table should have the data loaded.
That said it shouldn't be an issue as you would be restricting your data within your pbix anyway using the parameters.
Reference: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

[Shubham_rai955 · Accepted solution]

@baby_owell , Incremental refresh can only be applied to tables that are loaded into the data model; you cannot set up incremental refresh on a query with Enable Load turned off. For your scenario, stage all transformations and merging in Power Query, but make sure the final result table is loaded (enabled) in the model before applying incremental refresh. After setup, you can minimize model size by only loading the final merged table, intermediate tables can stay unloaded.