Forum Discussion

AFoulk's avatar
AFoulk
Icon for Helper II rankHelper 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
AFoulk's avatar
AFoulk
Icon for Helper II rankHelper 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