Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

RLS

Hi, is there a way of implementing RLS and then changing the data visible in the Cards. For example, if general has Cost and User 1 has Cost multiplied instead? or is there a DAX formula I can add t...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Sorry to reply late.

     

    You can also try something like this:

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler 
So i've been asked to create Row level Security to manage access 

I have a Manager who requires all the data however, he has a team who requires limited data which isnt the same. 

For example, if he has the total cost and total profit as 'X' amount for all areas he manages he wants his team to have their own departments information but more than that he wants the information to be edited slightly to add 'X' amount to the value or to have the visuals pick up a different column. 

 

Also, If he can see a visual with cost and another with revenue, is there a way to change it for the team users so they see a different cost and revenue figure more related to their department?

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous OK, so you could use a column security pattern: Column Level Security in Power BI - Microsoft Power BI Community

 

Also, there is now Object Level Security (OLS) in Tabular Editor: https://powerbi.microsoft.com/en-us/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/

 

Also, in theory you could use USERPRINCIPALNAME in DAX to identify the person and return the appropriate calculation.