How to authorize user in Power BI Report and Daskboard

Question

Dear EveryoneI have a dashboard and report that is used for 34 Properties. There are many different people will use this report.&nbsp;And the security requirement is that Manager in Property 1 can not allow to see the number in report and data of Property B.&nbsp;Each property have about 10 person need to use this Report who belong to different cost center. And the head of deparment 01 can not allow to see the number and data of department 02.&nbsp;My question is how can I authorize user by Property and by Cost center.&nbsp;Thanks and Regards,Thuan Van Tang

anonymous · Answer

Dear pazhenMy solution is use :Userprincipal funtion to define the user login file in User table.And, Use switch(true(),..) in managing role.With this, can maintain very quickly for more than 500 people with one dax funtion in managing role in term of individual segement and multipul segment.&nbsp;

mitsu · Answer

Hi ,&nbsp;&nbsp;You&nbsp; must create RLS on the Power BI model . Essentially creates roles by property and assign users to these roles based on your requirement . The Roles can be created in the PBI desktop . FOllowing link should help .&nbsp;&nbsp;https://docs.microsoft.com/en-us/power-bi/service-admin-rls&nbsp;&nbsp;Thanks,Mitsu

anonymous · Answer

Dear MitsuI have tried with row-level securtiy,It already work in case each person only see each segment.How can i authorize for one user who can view many segment or all segment.For example: Email: thuantv can see HTL01 and HTL10&nbsp;This is my Dax in Row level security in which user1 is measure =&nbsp;USERPRINCIPALNAME()&nbsp;[Property] = Switch(true(),'Authorization user'[User_1]="thuantv@vingroup.net","HTL01",'Authorization user'[User_1]="cuongtt4@vingroup.net","HTL02",'Authorization user'[User_1]="lamnt31@vingroup.net","HTL03",'Authorization user'[User_1]="congntk1@vingroup.net","HTL04",'Authorization user'[User_1]="longdh5@vingroup.net","HTL05",'Authorization user'[User_1]="hungnq20@vinpearl.net","HTL06",'Authorization user'[User_1]="thanhnt102@vingroup.net","HTL07",'Authorization user'[User_1]="thonhc@vingroup.net","HTL08",'Authorization user'[User_1]="ktt@vingroup.net","HTL09",'Authorization user'[User_1]="halt32@vingroup.net","HTL10",'Authorization user'[User_1]="anhnt216@vingroup.net","HTL08","")

anonymous · Answer

Anonymous&nbsp;I don't see how is your data look like but generally you are able to assign data access using RLS. Something like this:&nbsp;https://docs.microsoft.com/en-us/power-bi/service-admin-rls&nbsp;Best,Paul

Forum Discussion

How to authorize user in Power BI Report and Daskboard

4 Replies

Related content

Keyboard-Only and Code-First Workflows for Report Authoring?

Individual authorization for refreshing a report

Kudos and the Top Kudoed Authors widget

New paginated report authoring experience - Unexpected Error

Tenant Not authorized For Cluster