Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Restricted access (Customized access) to Dashboard

Hello,

 

I have recently conducted a survey in my organization regarding employee well being. 

I used Microsoft forms for the survey and successfully automated transfering data to Power BI (used a streaming data set).

 

Now I want to publish the Dashboard to all the empoyees, but with the following restrictions.

 

1. The employees should see the results of their departments only ( I am collecting the each respondents department name along with the survey)

 

2. There is an additional section for comments, the comments should be visible to only team leaders whose team size is not less than 5 members.

 

 Looking forward to help.

 

Thank you.!

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks You for your response.

       

      I have implemented Row Level Security (RLS) in the Dashboard and it is working fine when I published it in my Workspace. (I have to make sure that team leads see the survey results of their team only)

       

      The problem arise when I publish the Dashboard in the department workspace. Since all the team members have "Member" Access RLS is not working fine and everybody will be able to see all the data. I have also tried Dynamic RLS taking hint from some Microsoft forums, but same results with that also.

       

      Can you suggest a solution to this? Or is there any alternate way to restrict the data content in power bi?