Forum Discussion
How can I combine multiple SQL Database sources staying DirectQuery?
For example: I DirectQuery some tables on our SQL server that are under a seperate database for Inventory, but I also want to grab some DirectQuery data from another database on that same server from...
Hi AFoulk,
Current power bi not support connect to multiple sql databases with directquery mode.
Limitations of DirectQuery
There are currently a few limitations to using DirectQuery:
All tables must come from a single database
For detail information you can refer to below link:
Use DirectQuery in Power BI Desktop
I'd like to suggest you link these database to one then use power bi to get data from the merged database:
Merge Multiple Databases into a Single Database
Regards,
Xiaoxin Sheng