Forum Discussion
SSAS Tabular vs MultiDimensionalCube - Please advise
You can't create PowerBI level measures (using DAX )when authoring a report that is connected live to an SSAS multidimensional model. you can do this with SSAS tabuler model.
Please go trough the below links for more details.
mark77 , Once you create a live connection with SSAS cubes, you can not create columns, You should be able to report level measures -https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data
refer:https://radacad.com/directquery-live-connection-or-import-data-tough-decision
Hi. Yes. This appears to work with tabular model. But not with multidimensional model. And that was the part I was struggling with. I had hoped that with the SQL Server 2019CU5 release this had been made possible. But it appears not to be.
