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.
bcdobbs yes you can do it if you are using XMLA endpoint which smpa01 was trying to do. I just tested it, connect it to the remote Power bI dataset using XMLA endpoint, and wrote the custom DAX query to get the result that I want. In theory, it is possible.
✨ 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.⚡
Do mean connect to a composite model via xlma endpoint and run query against that? Or have you found a way to bypass the composite model layer? If so could you send an example query?