Merge Queries as New creates an Import query

[Anonymous]

I'm talking to a remote SQL server and have set up 2 Direct Queries. When creating an inner join on these 2 tables using Merge Queries as New, the resulting query has a storage mode of Import. These are fairly large (1 million+ rows) tables, so the data load on the resulting query takes a while. Is there a way to keep the merged query as a Direct Query?

[amitchandak]

@Anonymous , Merge will create an import mode table. Better to create a view on databases.

While creating a connection few connection allows to write a query. See if that can help. I doubt it is allowed for direct query

[Greg_Deckler]

@Anonymous No, you would need to create a view or something in the source.

[Anonymous]

@Greg_Deckler Thanks. Am I using the best method for inner joining 2 direct queries?

[Greg_Deckler · Accepted solution]

@Anonymous Yes. You can do NATURALINNERJOIN in DAX but Power Query is best for this sort of thing in general.