Forum Discussion
Row-level filtering and hiding column
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!
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"
-
-
4 Replies
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"
-
-
Hi julian_urrea
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
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.Hi julian_urrea
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.
