Data visualization with specific permissions

[Munawar1881]

Hi All,

I need help!

Is it possible if I can created a dashboard and want to visualise it by permissions? 

e.g. 

I have created a dashboard of 10 salesman where CEO can see the progress chart or table of all salesman but when salesman1 access the same chart he can only see the chart or table of his own, Salesman1 cannot see the table or chart of otheres.

Thank you so much for your answers.

Munawar

[v-yalanwu-msft · Accepted solution]

Hi, @Munawar1881 ,
You could use Dynamic Row Level Security,

Dynamic RLS works with both internal or guest users.

You need to invite external users as guest users first. You need to invite external users as guest users first. Invitation methods are planned invites and ad hoc invites. Please refer to the following documents for details on how to operate: Distribute content to external guest users with Azure AD B2B - Power BI | Microsoft Docs

The next question is how dynamic row level security (RLS) work with Azure AD B2B. Please refer to the following documents: Distribute Power BI content to external guest users using Azure Active Directory B2B - Power BI | Mi...

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[gauthamboppana]

@Munawar1881  - Yes, you need to set up 2 RLS roles. One for sales person which filters for the sales person email and another for CEO (with no filters on the table). 

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

[Munawar1881]

Thank you for your response. but actually, I am creating a report for some other company and their users are not added in my account (I have an admin account PRO) will it work for external viewers. I mean that I have prepared a visual report for your company you are a third-party company and now I want to give full report access to you but a limited access to your salesman. In which he can only view his own details.