Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Set security only for certain data

Hello all, We have a financial Power BI report which can basically be viewed by anyone in the organisation, however, only a limited number of people can see the profitability figure. Right now,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous:

So I still need to include each normal user in this role table? 

I am looking for a solution so I can avoid doing so, as there are endless number of normal users. I would like to manage only the list of managers, and anyone who is not in that list, will automatically have normal user right. Is there a way to do so?

Thanks,
Van

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

>>So I still need to include each normal user in this role table? 

Nope, my formula only check manager tag, if formula can't find specific user's tag, it will also return error and will be catched by ISERROR function.

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

    Sorry for the late following up from this topic. I test the solution that you suggested. However, I still need to add each users on the row-level security in the app version. Otherwise, they will see this error message. Are there any other solutions to avoid doing so, as there are countless number of people that I would need to add here? Thank you!