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 if you are using Power BI or AAS as a data source, yes, you can combine models called composite models (mainly known as DQ over Power BI and AAS) you can read more here. I hope this is what you are looking for. Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs
✨ 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.⚡
parry2k thanks for looking into it. But this is not what I was looking for. I was not looking for a composite model at all.
I am looking forward to do something like this (if possible) so that I can utilize the same in dataflow as well.
(where table t1 is from DB t1 and table t2 is from DB t2- but both reside on the same SSAS server)