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
I think an alternative to solve your question, but you need Power BI Services. You can create differents reports per each data source by direct query in power BI desktop, then publish them in power bi service. Finally create a dashboard that shows a mix of report parts.
How can I mix two reports into one dashboard? can you help me, please?