Forum Discussion
SSAS Tabular Vs SSAS Multi Dimensional
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
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?)
Fair enough, but as far as I know it's only Cell security that is not supported.
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.
sdjensen hi i am not referrring to power bi RLS , i am referrign to role based security in the mdx cube.
sdjensen this is what i am referring to
SSAS MD features that isn't currently supported by Power BI:
- Cell security – you will not be allowed to connect!
That is not the same as RLS. That is a special multidimensional feature, but if you set it up it will NOT work in Power BI, but Cell security is not that same at "normal" security on multidimensional cubes.
sdjensen yes i never mentioned RLS i said role based, which is both cell and dimensional, i am looking for somethign that gives granular security.
