Forum Discussion

Mattmcdowell_'s avatar
Mattmcdowell_
Helper I
7 years ago
Solved

Direct Query Mode: merging queries as new query

Hi all,   I am working on a tool that requires up to date information, therefore I am using direct query mode on all my queries. However I merged a queries as new (that I am using for my visual) an...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Mattmcdowell_

     

    Please have a look this thread in 2016.At that time,Merge Queries as New, Append Queries and Append Queries as New are not supported when we connect to the same SQL Server database in DirectQuery mode.Now it is supported because of the new feature composite models in 2018.7.Here is the blog about this feature.

     

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Mattmcdowell_

 

Please have a look this thread in 2016.At that time,Merge Queries as New, Append Queries and Append Queries as New are not supported when we connect to the same SQL Server database in DirectQuery mode.Now it is supported because of the new feature composite models in 2018.7.Here is the blog about this feature.

 

Regards,

Cherie

  • Mattmcdowell_'s avatar
    Mattmcdowell_
    Helper I
    7 years ago

    Thanks Cherie