Forum Discussion
Solved
DAX query on different DB but same SSAS server
lbendlin TomMartens GilbertQ bcdobbs parry2k d_gosbell
I have not learnt who are the SME on this and if you feel that there is someone else who can help me on this please don't hesitate to tag. S...
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.
