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
Anonymous
Not applicable

Display only certain columns for each role

Hi, I have an Excel file with several columns in which there are data, budget and Invoice amount of every warehouse of the company. I've created a row level security role for each warehouse on my powerBI file and imported the Excel. I would like to display only relative data for each role while hiding other columns. I tried to fix it on Tabular editor but I didn't find anything related to columns, only tables.

Here's the link at the Excel file: https://drive.google.com/file/d/1wF81egZtQwejqL57Vig0ehYgcxpFTU8X/view?usp=sharing

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , perspectives and object level security can help, please check

https://data-marc.com/2020/08/18/power-bi-visual-customization-using-perspectives/

https://powerbi.microsoft.com/en-us/blog/object-level-security-ols-now-available-for-public-preview-in-power-bi-premium/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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!