Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Change value of a column based on the role applied via RLS

Hi, I am using power bi embedded and using RLS to restrict the users viewing some rows once they are logged in.   There are some columns in my dataset which i would like to hide for some of the us...
General Comment
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

You could put the columns in a separate table.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Putting them in a separate column is not the solution to this because i want to put in a condition for calculated column or change the value of that column if the user has got access to it or not. 

 

Like showing ****** for users who dont have access and showing the value for the logged in users who have access.

 

the calculated column is not letting my apply the username condition neither directly nor via a measure.

 

hope I have explained it better now.

 

Thanks

 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Anonymous,

     

    You may leave a comment and vote this idea up.

  • drishti's avatar
    drishti
    New Member
    4 years ago

    Did you get a solution for this?