Row Level security

[Mana_786]

Hi All,

Am new with PBI I have problem with row level security.The scenario is like this I made monthly report from sales actual Target and last year sales Now I want to share this repot with other people With CFO CEO And all area managers .I want that CEO CFO can see whole report but Area manager can see only his area report .Do I need to make seprate report For Every Area or what should I do ?

It would be nice if somebody can guide me in detail.

Thanks

[Salvador]

Hi,

You should use Row Level Security, and there, create the different roles, with different permissions for each role.

In my case, for example, I have one role with full visibility (No filters applied), and then one role for each area manager, with its respective filters.

[Mana_786]

Hi ,

Perfect I undestand this point I made diffrent role for diffrent Area managers And I Also checked on web portal through security from data set. I saw the Area manager form Area A Can only see the sales from area A But I dont understand How can I share with them The specfic Area A report taht He can only see Area A sales Not other Do  I need to share Through dashboard or only Report ?

Thanks

[Salvador · Accepted solution]

Hi,

I assume you have a pbi file with multiple sheets, as the one I have.

You would have 2 solutions,

1) Create a pbi file with the report for the managers, and other for the users with full access, you can use the main report as source data to create the new ones.(Just in case there are things that you dont want the area managers to see), check this post 😄 http://community.powerbi.com/t5/Desktop/Master-report-amp-subreport-question/m-p/203814#M89694

2) Create a dashboard for managers and another one for the "vips", but be aware that from the dashboard, users can access the report, and from there, navigate and find more info.