What is row-level security in Tableau?

Row-level security (RLS) restricts which rows of data an individual user can see in a published view, so the same dashboard shows different data to different people based on who's logged in — without needing to build a separate workbook per user or team.

User-filter approach:
{ FIXED : IF USERNAME() = [Sales Rep Email] THEN 1 ELSE 0 END } = 1

Or using a mapping table:
[Region] = LOOKUP(current user's allowed region)

• The most common pattern joins or references a permissions/entitlement table mapping usernames (or groups) to the data they're allowed to see.
• A calculated field using USERNAME() or ISMEMBEROF() compares the logged-in user against that entitlement data, and is used as a filter on every relevant worksheet.
• RLS is enforced at query time on Tableau Server/Cloud, based on the identity of whoever is viewing the dashboard.

RLS is essential for any shared dashboard containing sensitive or role-specific data — for example, a regional sales dashboard where each sales manager should only see their own region's numbers, all served from one single published workbook rather than dozens of near-identical copies.

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.

Webull! Receive free stock by signing up using the link: Webull signup.