Forum Discussion

akhil5656's avatar
akhil5656
Frequent Visitor
8 years ago
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...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
akhil5656's avatar
akhil5656
Frequent Visitor
8 years ago

Is there any other way to connect two or more database live in Power BI Desktop?

BILASolution's avatar
BILASolution
Solution Specialist
8 years ago

akhil5656

 

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.

  • Ashe_-123's avatar
    Ashe_-123
    Frequent Visitor
    3 years ago

    How can I mix two reports into one dashboard? can you help me, please?