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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.