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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you. I will try this and see what happens. Much appreciated. 

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

Anonymousyour solution is ok but if any of the field is used in report and is not available in data model based on user column selection, report will stop working, so I personally don;t think it is advisable to not to return the columns to the model , it is better to make multiple roles based on user and remove those columns. 

 

Let me know if I missed something.

 

So solution is to create calculated column and remove value from the column, it will break any report.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for this. While the formula works to put a dash, the problem is since we can't turn off underlying data they can still export the aggragate and see the salary information.

     

    I'm so bummed out about this. :( :( :( :( 

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

      Anonymous In my very first reply I mentioned you about this. You really need to create seperate report and remove this field from data model, there is no other way at this point. If there was ability to pass user name to "power query", it would have been nice. You have to mask your data at source end or remove the column from model.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I know. I just wish underlying data could at least be turned off and not just full export.