Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
XTF
Frequent Visitor

Create Roles to define user with full access to a report

Hi all!

I have 1 Workspace in Premium Capacity with 2 Reports, Report1 and Report2.

Both reports must be accessed by different user groups. I have John and Sarah that can only look into Report1, and Peter  and Bruno that can only look to Report2.

All of them have acess to the same workspace where the 2 reports are available.

How can I make that happen? Using RLS? Not sure if this is possible.

Thanks!

1 ACCEPTED SOLUTION

@XTF RLS works on data only not for whole report.

Provide Viewer access to all 4 users to both the reports.

Create roles in each of the report.

In published report go to Security and add John and Sarah for Report1 and Peter  and Bruno for Report2.

If Peter logins and is able to browse the report1 , peter cannot see data inside.

 

Regards
DI

Did I answer your question? Mark my post as a solution, this will help others!
Kudos are also welcome.

View solution in original post

4 REPLIES 4
XTF
Frequent Visitor

Than you! I could implement it.

darshaningale
Resolver II
Resolver II

Users in different user groups can be provided viewer access to the workspace.

By implementing RLS in both the reports , one user group cannot see other user groups reports.

 

Regards
DI

Did I answer your question? Mark my post as a solution, this will help others!
Kudos are also welcome.

Hi darshaningale , thenks for the answer.

The problem is, how do we create this RLS? I mean, technically. An example would be great.

I've seen several turorials on how to limit a user to see a certain part of the fact table, etc... but how to make users be able to see or not to see a full report using RLS?

@XTF RLS works on data only not for whole report.

Provide Viewer access to all 4 users to both the reports.

Create roles in each of the report.

In published report go to Security and add John and Sarah for Report1 and Peter  and Bruno for Report2.

If Peter logins and is able to browse the report1 , peter cannot see data inside.

 

Regards
DI

Did I answer your question? Mark my post as a solution, this will help others!
Kudos are also welcome.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.