Forum Discussion

dguevara's avatar
dguevara
Icon for Advocate IV rankAdvocate IV
10 years ago

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...
Need Help
dguevara's avatar
dguevara
Icon for Advocate IV rankAdvocate IV
10 years ago

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?

  • greggyb's avatar
    greggyb
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    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.