configuration of incremental refresh

[sebastienke]

Hi, 

I would like to set up an incremental refresh in my model, but when I refresh it in power bi service, historical data don't appear. They seem to not have been loaded.

I think I know why, but before changing all my model to test it (which will take a lot of time) , I prefer asking the question here first.

In all my queries, I have created one query which allows me to set up common steps for different others queries, including the date that I use to configure my incremental refresh.

• "_Setup - Stock + E&O" is loaded into my model (I don't have choice if I want to configure it with an incremental refresh)
• "STOCK" is loaded into my model and this is the table in which I want incremental data  
• Stk tot, Stk VB, Stk X3PF are not loaded into my model (I don't want to) but they are queries that I need to merge to build "STOCK"

So my question is this one :

do you think that the reason my incremental refresh is not working is because the choice of date is not in the same query than the final one ("STOCK") ? or maybe because I am using intermediate queries that are not loaded into my model ?

Thank you for your help 🙂

[sebastienke · Accepted solution]

Actually I have found a solution here :
https://www.thinkbi.de/2020/03/29/incremental-refresh-with-subqueries/

DateTime parameters used in subqueries need also to appear in the final query, even if it is a "fake filter".

[lbendlin]

" including the date that I use to configure my incremental refresh"

Incremental Refresh needs DateTime parameters.