Forum Discussion

vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

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...
Need Help
sdjensen's avatar
sdjensen
Solution Sage
8 years ago

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."

vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

sdjensen yes the scenario here is to implement role based security in an MDX cube, using a direct query connection on Power Bi Report Server, sorry i dont quite understand what you saying it does work or it doesn't?  will check out the documentation

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    8 years ago

    sdjensen also what is ETL?

     

    • Only ETL, and DirectQuery connections are supported. Live connections to Analysis Services are handled in the on-premises model.

    extract transform load (ie imported mode?)

    • sdjensen's avatar
      sdjensen
      Solution Sage
      8 years ago

      An ETL source could be a SQL database where you import data into your model. You can't user Power BI RLS for live connection to cubes - here security is handled with roles in the cube.

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        8 years ago

        sdjensen hi i am not referrring to power bi RLS , i am referrign to role based security in the mdx cube.