Forum Discussion
Merge Queries as New creates an Import query
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?
Anonymous Yes. You can do NATURALINNERJOIN in DAX but Power Query is best for this sort of thing in general.
4 Replies
- Greg_Deckler
Community Champion
Anonymous No, you would need to create a view or something in the source.
Greg_Deckler Thanks. Am I using the best method for inner joining 2 direct queries?
- Greg_Deckler
Anonymous Yes. You can do NATURALINNERJOIN in DAX but Power Query is best for this sort of thing in general.
- amitchandak
Super User
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
