Forum Discussion

AFoulk's avatar
AFoulk
Helper II
9 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

  • AFoulk's avatar
    AFoulk
    Helper II
    9 years ago

    Thank you for the feedback. We wouldn't be combining databases. There would be too many changes required and not worth that effort just to satisfy my BI needs.

     

    I am continuing to play around and see what I can come up with to satisfy my end goal until Microsoft is able to make updates to BI that combining the end results somehow into 1 BI file is an option.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi AFoulk,

       

      Perhaps you can submit your requirement to ideas.

       

      Regards,
      Xiaoxin Sheng

      • AFoulk's avatar
        AFoulk
        Helper II
        9 years ago

        I found what appeared to be a similar or same type of request in the ideas area that just broke 100 votes. I would think that type of update shouldn't be too tough for allowing multiple sources to join together, but that isn't my expertise. I'll keep my fingers crossed :smileyhappy: