Forum Discussion
Two SQL servers in directquery
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 automat...
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/
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