Forum Discussion
Solved
How to connect two data sources with direct query
I am creating a dashboard to monitor SQL Agent jobs on Power BI Dashboard for different servers in my network. I have connected one data source with the direct query and when I am trying to connect t...
Hi akhil5656
Nowadays, you can't do that...
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/
Regards
BILASolution
You can now connect to more than one direct query souces, introducing Composite Models in November 2018.
All tables should be in a single database is no longer a limitation
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models