Forum Discussion
Solved
Power BI On Premise - Applying Row Level Security
Hi all, I have recently set up a Power BI On Premise Report Server. From there I created a report in Power BI Desktop and saved it on to the report server, this report is using Direct Query to do...
Please check that you have done the following step.
After the report is uploaded to PBIRS;
- Go to the PBIRS folder that pbix is residing.
Each pbix is shown in a tiled view with 3 dots on the top right hand corner.
Click those 3 dots and select "Manage" -> "Row-level security"
Click "Add Member"
Here, you have to add AD usernames or AD groups to the security-role you defined in PB Desktop. - Instead of adding each user/role, I think "Everyone" group can be added here, so that Row Level Security can appropriately filter rows for each user.
- Go to the PBIRS folder that pbix is residing.
Any update on this? It appears that username() and userprincipalname() are still routing to the same result once published.
This behavior was a design choice, both username and userprincipalname returns the value of userprincipalname. This is consistent with the experience with reports published to powerbi service.
Thanks
-Boreki