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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BigLo
Helper II
Helper II

Limit access to the dataset

Hello,

 

I've a dataset that is common to the employees of my company.

I would like when a user logs into a DashBoard, they only see their own information and not that of their colleagues. The Dashboard is published on a common workspace.

I've the identifiers of these colleagues and I've the information that determines which data it can view. What is the best technical solution for this?

 

Thanks

2 ACCEPTED SOLUTIONS
_sfrost
Solution Specialist
Solution Specialist

@BigLo 

This can be achieved with Row Level Security (RLS). You can create roles according to your requirement and assign it to the users who have access to the dataset. 

Once the roles are assigned to those users, they will only see their respective data as you would like.

Reference: Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

 

Did I answer your questions? Give a thumbs up and accept this post as solution!

View solution in original post

_sfrost
Solution Specialist
Solution Specialist

@BigLo @When you create a role and assign it to a user, it is expected that the user has read only access. If the user has edit access on the dataset, RLS will not work.

Since we give read only permission, the end user will not be able to download the report. Hence he won't be having access to any underlying data.

View solution in original post

5 REPLIES 5
_sfrost
Solution Specialist
Solution Specialist

@BigLo 

This can be achieved with Row Level Security (RLS). You can create roles according to your requirement and assign it to the users who have access to the dataset. 

Once the roles are assigned to those users, they will only see their respective data as you would like.

Reference: Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

 

Did I answer your questions? Give a thumbs up and accept this post as solution!

Hi,

 

Do the users to whom the data is restricted need to have a Power BI account?

In my case they are external users and not all of them have power bi accounts. I just want to send them a link to the dashboard so that the data is restricted to their data only.

See my post, please

 

External Sharing with limited data access - Microsoft Power BI Community

 

Great! Very simple and efficient.

 

But if the user download the pbix file, he don't have access to underlying data? 


Is there another vulnerability that I should pay attention to?

_sfrost
Solution Specialist
Solution Specialist

@BigLo @When you create a role and assign it to a user, it is expected that the user has read only access. If the user has edit access on the dataset, RLS will not work.

Since we give read only permission, the end user will not be able to download the report. Hence he won't be having access to any underlying data.

Thank you for your clear and complete answer!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors