Oklahoma Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Row Level Security Feedback/Direction

  • 1.  Row Level Security Feedback/Direction

    Posted Jul 12, 2019 06:11 PM
    Hey everyone!

    Thanks for allowing me to join today. I am in my 2nd week at BOK doing workforce analytics. We are still new to using PowerBI so we are hoping some of you may have some experience or know in more detail regarding setting row level security for your reports/dashboards. We are obviously a large organization, so I didn't know if anyone knew of a faster way than inserting dax expressions at the dashboard/table level.

    Any input would be appreciated!



    Tisha West
    Workforce Analytics Consultant

  • 2.  RE: Row Level Security Feedback/Direction

    Silver Contributor
    Posted Jul 16, 2019 12:08 PM
    Good morning, @Tisha West, and welcome to the group!

    Do you know if the data is being imported or queried into your Power BI report?

    It depends on where the data really "lives". If the data is imported, you can use Power BI's built-in row-level security with these buttons. But in this case, it's definitely a report-level configuration and requires DAX to make it work.Taken from https://docs.microsoft.com/en-us/power-bi/service-admin-rls

    If the data is being pulled through DirectQuery (from SQL Server for example) or from a Live connection (from SQL Server Analysis Services) then the row-level security can be applied at the database level. The key to making this work, however, is that the database must know who the user is in order to properly filter results. If the data is truly sensitive, this is a preferred approach. It keeps the data centralized, minimizes copies, and gives you one place to both control and audit access: on the database server.

    I'm pretty sure I'm not answering your real question - would you mind posting an example of how you are currently doing the row-level security? - Brent

    PS - if you end up searching for more information online, row-level security is frequently abbreviated to "RLS". ​

    Brent Lightsey
    Analytics Consultant
    FirstLight Analytics
    Oklahoma, USA