Forum Discussion
DAX query on different DB but same SSAS server
I don't think you can do it directly like you're trying.
The closest you could get is to follow parry2k suggestion and drop both models into a composite model and publish to premium workspace. To an external xlma connection that then behaves as a single model on which you could run your natural join.
Would be amazing if you could query directly like you suggest in SSMS or DAX studio but I suspect given the work that microsoft have had to put in to make composite models function I'm not sure it is. Happy to be corrected though.
smpa01 bcdobbs exactly what AlexisOlson suggested. That's what I was referring to, doing merge in PQ if two different datasets, if it is a single dataset then write DAX query
Cheers!!
P
parry2k thanks for clarifying. I already knew that these tables can be brought over to PQ and do the rest, but I really want to bypass that and have the transformation on the server-side if possible. That is the original intent. Given PQ's performance issue, I really don't want to involve it, unless I absolutely have to.
