Forum Discussion
Power BI On Premise - Applying Row Level Security
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.
We shipped RLS support with the January release. But in order to see data you need to add the user to one of the roles in the report (even for the user who is updating the report), follow the steps in the "Add member to Role" section in this link:
https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server
This is not very explicit, but its called our as part of the limitations on that page.
Let me know if you still runs into problems.
Thanks
-G
So I have done that, I have a UserName field which I set to [email protected]. I then take that UserName field and set up a Role called UserSec where I enter the DAX UserName = USERNAME(). I click the tick and this is fine. Following this I uploaded the report to the On Premise Report Server and all of a sudden I cannot see any data, I just get errors saying that the user does not have permission.
If I go to the Power BI Service and login in I can set up RLS in the Security tab and then the security works as it should (in the Power BI Service), but I want security to work directly on the On Premise Report Server as using the Power BI Service defeats the point for us.
What I need to do is:
1) Create a report in Power BI Desktop
2) Add a Role to that report (using DAX) that links a field to the USERNAME()
3) Save the report from Power BI Desktop to the Power BI On Premise Report Server
4) View the report on the Power BI On Premise Report Server with RLS active
Is that possible?