Forum Discussion

smpa01's avatar
smpa01
Community Champion
4 years ago
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...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    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.

parry2k's avatar
parry2k
Super User
4 years ago

smpa01 although try this, you have to use EVALULATE  to return the table

 

EVALUATE
NATURALINNERJOIN( <<first table>>, <<2nd table>>)

 

✨ Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡