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 automatically be imported.. any help?
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/
2 Replies
- amitchandakSuper User
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/
- AnonymousNot applicable
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