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.
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.
bcdobbs apologies for the delay in getting back to this. bcdobbs this is a brilliant suggestion. Yes, can't make SSAS behave like SQL at this point of time (with different DB but on the same server).
The workaround is to put the SSAS DBs on a composite model and then all the DBs are available for combined transformation/query. bcdobbs awesome !!!