Dynamic RLS: which rows does each user see?

Sample layout — fictional data. Orders 301–308 from visuals_orders_apr_may_2026.csv. Security table: email → City.

Viewing as Rani · Orders 8 · Total Sales ₹2,100
OrderCityStoreAmount (₹)

In Power BI Desktop: Modeling › View as › tick “Other user”, type the email, tick the role › OK. Workspace Admins, Members and Contributors are not filtered by RLS.