Forum Discussion
dguevara
10 years agoAdvocate IV
Best way to develop and implement a solution
Hi Everybody... what is the best way to implement an enterprise solution working with large databases, because I can develop my model in Power BI Desktop and ok no problem, the problem is that there...
dguevara
10 years agoAdvocate IV
Anonymous thanks for the comment, but I've never used that route so I have a question, what happens when Power BI connects to an SSAS model?
1- Power BI would act only as a component of visualization and cloud storage?
2- Can I use DAX into Power BI with that SSAS model or Power BI also load these measures of tabular model?
- greggyb10 years agoResident Rockstar
When connecting to an SSAS data source in live explore mode, you are strictly consuming what exists in the SSAS model (regardless of Multidimensional vs Tabular). You cannot define new measures in Power BI when utilizing a live connection against SSAS. All of that modelling and measure definition must be completed in SSAS.