Power BI
Needs VotesRLS should be assigned automatically according to a pre-exsisting security table in a database.
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)
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.