Forum Discussion
Row Level security
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 :D 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.
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.
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
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 :D 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.