Row-level filtering and hiding column

[julian_urrea]

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!

[v-karpurapud]

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.

[v-karpurapud]

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.

[v-karpurapud]

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.

[SundarRaj · Accepted 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"