Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello community!
I’m currently facing an issue with a table. I have several roles, and depending on the role, each person can see certain information (row-level filters). Now I’ve run into a situation where I need to hide columns containing sensitive information that I don’t want all roles to be able to view.
I’d appreciate it if you could tell me how I can achieve this.
Thank you very much!
Solved! Go to Solution.
Hi @julian_urrea.
Open Tabular Editor
In Power BI Desktop, go to the External Tools tab
Click on Tabular Editor
Create or Select a Role
In the left pane, right-click on Roles
Choose New Role (e.g., NoAccess
) or select an existing one
Apply OLS to a Column
Expand the desired table to view its columns
Right-click the column you want to hide
In the Properties pane (bottom-right), scroll to:Translations
, Perspectives
, Security
Set Object-Level Security
Under the Object Level Security section, you’ll see your role listed (e.g., NoAccess
)
Next to the role, the default value will be Default
Click and change it to None
This hides the column for that role
Repeat for Other Columns
Apply the same setting for any additional columns you want to hide
You’ll see a message like:
"OLS enabled on 1 out of 4 columns"
We haven't received a response to our last message and wanted to follow up to see if you have found a solution. If you still need help, please share more details so we can assist you further.
Thank you.
I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.
Thank You.
Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to @SundarRaj for offering helpful suggestions.
Could you let us know if the suggested solution resolved your issue? This information can assist other community members facing similar challenges.
Thank you.
Hi @julian_urrea.
Open Tabular Editor
In Power BI Desktop, go to the External Tools tab
Click on Tabular Editor
Create or Select a Role
In the left pane, right-click on Roles
Choose New Role (e.g., NoAccess
) or select an existing one
Apply OLS to a Column
Expand the desired table to view its columns
Right-click the column you want to hide
In the Properties pane (bottom-right), scroll to:Translations
, Perspectives
, Security
Set Object-Level Security
Under the Object Level Security section, you’ll see your role listed (e.g., NoAccess
)
Next to the role, the default value will be Default
Click and change it to None
This hides the column for that role
Repeat for Other Columns
Apply the same setting for any additional columns you want to hide
You’ll see a message like:
"OLS enabled on 1 out of 4 columns"
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.