Two SQL servers in directquery

[Anonymous]

So I read that I can use composite mode to connect two or more sql sources in directquery And combine the data. However I cant find how to do this. If I connect my second sql database it will automatically be imported.. any help? 

[Anonymous]

Hi @Anonymous ,

It would not changed to import mode when I connect to another sql source chose with Direct Query in original source. How did you connect these sql sources? Did you choose the correct connection mode when connect to another data sources?

Best Regards

[amitchandak · Accepted solution]

@Anonymous , I think released in Dec -2020

Please check if these can help : https://www.sqlbi.com/articles/new-composite-models-in-power-bi-a-milestone-in-business-intelligence/

https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-services-preview/