Forum Discussion
vanessafvg
8 years agoCommunity Champion
SSAS Tabular Vs SSAS Multi Dimensional
if you are using power bi to develop dashboards from a cube, do you think its better to create the cube in tabular rather than MDX and why? currently we are creating a cube in via direct querry m...
vanessafvg
8 years agoCommunity Champion
sdjensen oh wow thats a big one, role based security doesn't work with mdx and direct query in power bi?
sdjensen
8 years agoSolution Sage
My post didn't mention RLS, but you can read about the limitations about RLS here: https://docs.microsoft.com/en-us/power-bi/service-admin-rls#limitations
RLS has never been used for live connections to Analysis Services this also apply to Tabular.
"Only ETL, and DirectQuery connections are supported. Live connections to Analysis Services are handled in the on-premises model."