Prevent merge table from changing to import mode in Power Query when originating from Direct Query

[Anonymous_001]

I created a merge table from 2 x Direct Query Tables. However the merged table got converted to import mode. How can I avoid this from happening?

Thanks in advance

[mlsx4 · Accepted solution]

Hi @Anonymous_001 

I think that the only thing you can do is to merge the tables in datasource and then, load the merged table in Power BI