cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dli9
Frequent Visitor

How to restrict user access?

I'm showing my student's performance results on a tab. Is there a way to restrict each person from viewing the rest of their peers? If I'm Michael, I can only filter Michael and not see the rest. There are many students so creating different tabs or separate dashboards (then publishing) isn't viable. 

 

I don't have pro/premium either, so i can't embedded the visuals to sharepoint or another site. 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @dli9 ,

If you want to realize that everyone can only see the data in their own rules, you can use RLS, in Power BI Desktop, by using the username() or userprincipalname() DAX function and configuring the correct relationship, you can assign it to the Power BI Service, and after the assignment is completed, share its report to others through sharing .

 

Notice:

1. The format of username() is DOMAIN\username, and userprincipalname() is used when the user is in the email format username@contoso.com.

2. When you use RLS, the user's role in the workspace must be View, otherwise the RLS fails and the user sees all the data

3. Whether you or the user, you need the permission of Power BI Pro.

 

This is the related document, you can view this content:

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-the-username-or-userprincipa...

https://www.edureka.co/blog/row-level-security-in-power-bi/

https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/ba-p/787399

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @dli9 ,

If you want to realize that everyone can only see the data in their own rules, you can use RLS, in Power BI Desktop, by using the username() or userprincipalname() DAX function and configuring the correct relationship, you can assign it to the Power BI Service, and after the assignment is completed, share its report to others through sharing .

 

Notice:

1. The format of username() is DOMAIN\username, and userprincipalname() is used when the user is in the email format username@contoso.com.

2. When you use RLS, the user's role in the workspace must be View, otherwise the RLS fails and the user sees all the data

3. Whether you or the user, you need the permission of Power BI Pro.

 

This is the related document, you can view this content:

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-the-username-or-userprincipa...

https://www.edureka.co/blog/row-level-security-in-power-bi/

https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/ba-p/787399

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

VahidDM
Community Champion
Community Champion

Hi @dli9 

 

If you don't have Pro or Premium license, how do you share the dashboard with students?

Please check these links:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

https://guyinacube.com/2020/02/25/can-you-use-groups-with-power-bi-row-level-security-rls/

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors