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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.