Forum Discussion
SSAS Live Connection and Mutiple Data Sources
I know that we allready have a lot of posts on this topic and that there is an "idea" created on the subject: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12532173-ssas-get-data...
Hi jockefe,
Handling more than one SSAS database with the LiveConnect mode is certainly a very complex task. In this mode Power BI does not have a data model and rely on the one in SSAS.
But in SSAS you cannot do a DAX/MDX query that crossjoin data from 2 different databases. And this is clearly a showstopper.
Best Regards,
Angelia
Hi jockefe,
If you have resolved your doubt, please mark the helpful reply as answer, so that more people will benefit from here.
Best Regards,
Angelia