How to Use RLS in Power BI



Guide

  1. Go to the 'Modeling' tab.

  2. Click 'Manage Roles'.

  3. In the Manage Roles window, click '+ New' under the 'Rule' section.

  4. Give the role a name.

  5. Pick a table you want to filter.

  6. Click 'Switch to DAX editor'.

  7. Type the DAX formula.

  8. Click 'Save' to apply changes.

  9. A confirmation pops up once you have successfully implemented Row-Level Security in Power BI.

  10. Select 'View As' to check your RLS.

  11. Choose a role and select 'OK'.

  12. That's it! You can use the RLS in Power BI by following these steps.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline