Incremental refresh

Question

Good morning all ,I implemented an incremental refresh.https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/I created 3 tables a "don'trefresh", a "refresh" and an "append" which is the addition of "don'trefresh" and "refresh". I have disabled the option "include in refresh report" on the table "dontrefresh". The result in power bi is correct unfortunately when I go back to power query to create another table or modify some things, it updates me all the tables, even the "dontrefresh" ...What solution do you offer me?Thanks for your help.

greg_deckler · Answer

ImkeF&nbsp;

skootz · Answer

You send me a message about my issue ?&nbsp;&nbsp;Thanks

imkef · Answer

Hi&nbsp;skootz&nbsp;,
this is an old workaround during the days when didn't have incremental refresh with pro-licenses.&nbsp;I wouldn't recommed it any more.
With regards to the refresh you can try to disable background refresh in the query options, but I haven't tried if this solves this yet.
&nbsp;

skootz · Answer

Thanks for your response :I have already configured the incremental refresh without these 3 tables, only, I have encountered a problem :&nbsp;I set up an incremental refresh on a table. I have a problem: it adds my new recordings to the table, but it does not keep the old ones. example: I have the records of my table Tab1 dated 08/31refresh 09/03 : addition of 09/02 records BUT REMOVAL of 08/31 records ... it does not keep in stock the 10 years that I have configured.Tab1 to 02/0908/31 : 5000 records09/01 : 1000 records&nbsp;Tab1 to 03/0909/01 ---&gt; 1000 records&nbsp;09/02 ---&gt; 200 records&nbsp;Do you have a solution for me for this ?

imkef · Answer

Hi&nbsp;skootz&nbsp;,
sorry, but I don't have a solution for this.
&nbsp;

Forum Discussion

Incremental refresh - power bi refresh automatically

8 Replies

Related content

Increment Refresh

Automatics Refresh

Incremental Refresh

Incremental Refresh on Dataflow sourced from SharePoint