Row-level filtering and hiding column

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"