Incremental refresh with appended queries

[HB13]

Hello all!

I have two tables (A and B) coming in from two different servers. They are identical in terms of their column names, number of columns, data types etc. 

A is huge and requires an incremental refresh policy set up on it. 
I now have to update the data model by including table B by appending it to table A.

How do I go about reinstating the incremental refresh? 
-Do I append A and B and then set the incremental refresh policy? 
-Do I append the tables as a new query and then set the policy?
-Can I keep the refresh policy on A, and then append B as a new query? 

I have tried the first two senarios and both gave me the "Unable to determine if M query can be folded" warning. Could it still work despite the query folding issue?

Many many thanks

[v-chenwuz-msft · Accepted solution]

Hi @HB13 ,

Apply incremental refersh on A and  disable query A load to power bi model. Then append A to B. Load B.

The same problem was solved in this thread.

Solved: Incremental refresh with several Appended Dataflow... - Microsoft Power BI Community

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DougieK]

'Enable load' must be turned on in order to toggle on the incremental refresh for a table.  Are you Toggling it on first, then unchecking 'Enable load' in Power Query afterwards?

[lbendlin]

Neither of the above?  How about doing a UNION in DAX?