Forum Discussion

Vegard1985's avatar
Vegard1985
Helper I
4 years ago
Solved

A mix between RLS and OLS?

Hi,   I couldn't find a similar post, so I'll check my luck and ask you guys. With the introduction to Object-Level Security, could there in any way be possible to set up a security that sort of i...
Need Help
  • manikumar34's avatar
    manikumar34
    4 years ago

    Vegard1985 , 

     

    Yes, that's a bit painful. Unfortunatley, for now I don't think we have other options here. 

Vegard1985's avatar
Vegard1985
Helper I
4 years ago

Ah, really?

Wouldn't that make sense, to atleast make a person only see specific rows and spesific columns in the same table?

 

I know my original question is a bit different, as I would like a person to see all rows, but only parts of a column.  That it's not even possible to filter both rows and columns in the same table in the same time surprises me a bit.

 

Edit:

Actually, that seems to work. Setting up an RLS-role, and adding an OLS column specific filter on that RLS-role works fine. The role can only see the intended rows and intended columns.

 

But ok, I guess my original question still remains a difficult task as of now..

manikumar34's avatar
manikumar34
Solution Sage
4 years ago

Vegard1985 , 

 

Actaully OLS is not fully developed on Power BI Desktop, for now we are using External tools like Tabular Editor or XMLA endpoints to make RLS whereas RLS can be developed on Power BI dekstop.