Append Query with DirectQuery mode

[stalerik]

I have two tables from two different databases in my Power BI model.  They contain the same columns.  I would like to append the two tables.  When I append the tables, I lose the DirectQuery ability and my data does not automatically refresh upon reload. I have tried the Append function in Power Query Editor, and also used a Union with DAX to create a new data table.  But my new table is switching to Import mode.   I would like to know a way to append the two tables into one table and keep the DirectQuery.    Thank you!

[v-xuding-msft · Accepted solution]

Hi @stalerik ,

Greg is right. It is not supported for DQ mode to append tables in Power Query and create calculated tables with DAX. As you tried, it is always changing to composite models. For now, there is not a good workaround to solve it. I think you could reference the document: Use composite models in Power BI Desktop to check if it is okay using the models. For composite mode, your original tables remained in DirectQuery mode and just the new tables with import mode.

You could reference the documents to learn more about DirectQuery.

About using DirectQuery in Power BI 

Use DirectQuery in Power BI Desktop 

Best Regards,

Xue Ding

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

[Greg_Deckler]

I am not aware that you can use Append or UNION in DAX and keep Direct Query mode.