How to give access for a dashboard with different privileges in Power BI?

[Elangamban]

Hi,

I've created a dashboard with all the sales data.

If I share this dashboard with the sales executives and sales managers, they should view only the data which are relevant to their owns.

Is there a way to achieve this?

Thanks...

[ruchikasharma]

I have a sales dashboard which prints sales in $$ plus prints COGS, GP and NP. I have a two-fold question: 

1) I’d like to give separate access to sales rep such that they can see only their sales data - this part is taken care of with Row Level Security.

2) Give access to sales managers so they can see sales data of all their direct reports. - this is the question I’m interested to find a solution for.

Thank you,

Ruchika

[Seth_C_Bauer]

@Elangamban You can do this with something called "Row Level Security". See here for more details.

[Elangamban]

Hi,

I've created a dashboard in power bi desktop with the whole organization sales data.I want to share the dashboard with the sales executives and their managers.

For the sales executives their own data alone should be displayed in the dashboard and for the managers the dashboard should display based on their reporting executives.

How to achieve this?

Thanks..

[Greg_Deckler]

You need to use Row Level Security.