Skip to main content

    Power BI

    New

    RLS should be assigned automatically according to a pre-exsisting security table in a database.

    Vote (8) Share
    's profile image

    on 14 Sep 2016 07:13:09

    RLS should be assigned automatically according to a pre-exsisting security table in a database. The table contains user names and which datasource/ rows they can access. This should automatically sync with PBI. We currently have a similar system for SSRS and this drastically reduces our workload by not having to maintain all the different groups

    Comments (1)
    's profile image Profile Picture

    221e86f4 76d6-4057-8607-81d9dd589004 on 05 Jul 2020 22:33:09

    RE: RLS should be assigned automatically according to a pre-exsisting security table in a database.

    I was able to set this up using the table and the DAX "Username () " function. The table had just 2 columns of user id and branch that user had access to. I used a relationship to the branch dimension table which can then filter out branches the user can or can not see. However, the issue is that when I publish this to the Service the dataset needs to have the RLS applied at individual users which is a pain. There should be an option to have it applied to ALL users. I have voted up the suggestion of "Add a default role for row level security" due to this.