Forum Discussion

Kashinoda's avatar
Kashinoda
Advocate I
8 years ago
Solved

Restrict Column Access with RLS - Almost there but some annoyances.

Hi All,   I have a Sales table which contains a SalesDescription, a small number of these descriptions are confidential - though everyone should be able to see additional sales information (SalesNu...
Need Help
  • Kashinoda's avatar
    Kashinoda
    8 years ago

    Managed to solve it by making the relationship between DimSales and FactSalesConfidential inactive then using a measure to return the description instead.

     

     
shebr's avatar
shebr
Resolver III
8 years ago

Hi Kashinoda

 

Can you provide the screenshot of your role formula? It seems to be doing what I expect it to be doing, not sure what you are trying to achieve exactly here? Have you added the 'regular' user to the role memebership or not?

 

Thanks

 

 

Kashinoda's avatar
Kashinoda
Advocate I
8 years ago

Hi shebr

 

Sorry by regular user I mean the 'Everyone' role, I've updated the original post to include the output from an older PowerBI version (which is what I want). Here is the role, very simple: