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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
alihijazi
Helper I
Helper I

data security

Hello

I'm new to PowerBI

I have created a dashboard and the data contains information about departments in our company

what I need to accomplish is the following:

several users want to access this dashboard but not all users are allowed to see all data

suppose I have 3 departments D1, D2, and D3

and there are 3 users

what I want is that User1 sees data related to D1, User2 sees data related to D2, and User3 can see all data

 

please advise on how to accomplish this

1 REPLY 1
asocorro
Skilled Sharer
Skilled Sharer

There are a couple of ways to accomplish this.  If your data source is SSAS Tabular with live access, you can use row-level security in your cube.  Otherwise, you can try RLS for your dataset in Power BI online:

 

rls.png

 

Detailed info here: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/.

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro

Helpful resources

Announcements
Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.