Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
julian_urrea
Frequent Visitor

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!

1 ACCEPTED SOLUTION
SundarRaj
Super User
Super User

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"

      SundarRaj_0-1754422178113.pngSundarRaj_1-1754422215675.png

       





Sundar Rajagopalan

View solution in original post

4 REPLIES 4
v-karpurapud
Community Support
Community Support

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
Community Support
Community Support

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
Community Support
Community Support

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
Super User
Super User

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"

      SundarRaj_0-1754422178113.pngSundarRaj_1-1754422215675.png

       





Sundar Rajagopalan

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors