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...
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.
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: