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.
Just a quick bump, does anyone know anything about this please?
I found out, that Power BI Report Server Version 1.4.6969.7395 (January 2019) converts the result of DAX function USERNAME() to
USERPRINCIPALNAME()
In PowerBI Desktop create a card visual that only shows the a measure called USERN.
Measure USRN looks like:
USRN:=username()
Deploy this report to PowerBI Report Server (January 2019) and you will see the result is:
User@upnsuffix and NOT Domain\username
PowerBI_Develop wrote:I found out, that Power BI Report Server Version 1.4.6969.7395 (January 2019) converts the result of DAX function USERNAME() to
USERPRINCIPALNAME()
In PowerBI Desktop create a card visual that only shows the a measure called USERN.
Measure USRN looks like:
USRN:=username()
Deploy this report to PowerBI Report Server (January 2019) and you will see the result is:
User@upnsuffix and NOT Domain\usernameNotice the same thing can someone confirm please if this is a bug and if it was raised to Microsoft
Thanks
Any update on this? It appears that username() and userprincipalname() are still routing to the same result once published.
Thanks for confirming this. I was wondering why my PB reports are not showing the USERNAME() correctly. Is this a bug?
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.
Thank you so much for your answer! I'm thrilled it is now working but I'm really annoyed that I had missed that.
When viewing the report server from my PC with my main user account I only saw Open in the list, I was surprised at first to not see Manage (as I'm used to using SSRS) but I just figured that everything was controlled in Power BI Desktop. It was only going on the server as another account that I could then follow your advice and find Manage...
As said, thank you very much, done a bit of testing and it looks to be working as expected! :-)
- Go to the PBIRS folder that pbix is residing.
