Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hiding a column based on a user

Hi Folks,   Just trying to figure out something. There is a small population of users that I need to give access to the reports, but they are not allowed to see a performance rating column. Is ther...
Need Help
Mitsql's avatar
Mitsql
Icon for Advocate II rankAdvocate II
8 years ago

Anonymous Try setting a role-based filter in power bi desktop before publishing to the cloud. Also, you can check using "view as role" before publishing.

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Mitsql it is for row level security, not column level. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    parry2k Is there a way to make it blank or with a "-" based on a user logged in? They only have read only access to the dashboards.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      parry2k Any ideas would be great please :)

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        8 years ago

        You can add calculated field and check if user has permission to see the value to that field or not and then make that field blank()

         

        here is link for reference 

         

        Just an idea

         

        Amount Hide = 
var r = IF(CONTAINS(UsersTable,UsersTable[login], USERNAME()), 1, 0)
return if(r = 1, Table[Amount], blank())