cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PatrickNealis Frequent Visitor
Frequent Visitor

Row Level Security "Test as role" in web browser no longer showing "view as ________" post update

Has anyone else noticed the Blue bar that popped up on the top of the Power BI web service is missing when you are trying to view a dashboard/report as another user? Specifically: Under Datasets --> Security --> Row Level Security -->Test as Role. Has this functionally been intentionally and permanently disabled?

 

In the past, you would see the dashboard/report with a blue bar that identified you were viewing the page "as user _____" and you could switch to an alternate user in that view as well. This was a critical way to confirm the RLS rules set in place were operational. 

 

For the record: I tried using the "view as roles" option for RLS rules in the Power BI Desktop client. I've tried using that version and it doesn't seem to work when trying to view as a specific user name. 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

@PatrickNealis  @swise001 @tsf  @alexhauge ,

This is a known issue that engineers are working on a fix, please keep an eye on the update time in Power BI support site.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

19 REPLIES 19
Super User
Super User

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

Hi @PatrickNealis

 

You are correct that the "Test as Role" has been removed from the Power BI Service.

 

If you want to test the settings you can do this in the Power BI Desktop, with the "View Role As"

The thing that you have to know is that instead of using the USERNAME() DAX function in Power BI Desktop you have to hardcode this with the user's UPN (User Principal Name) that you want to test it with. When you do it in this way you can see if you are getting the desired output.

 

I do have a blog post explaining some of the caveat's as well as a good link to Kasper De Jonge's post which has an overview of RLS (Row Level Security)

 

https://www.fourmoo.com/2016/10/03/power-bi-dynamic-row-level-security-things-you-need-to-know-to-ge...


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
tsf Regular Visitor
Regular Visitor

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

Do the browser-based reports still use the USERNAME() value when applying security? From my experience, it seems like testing security in PBI Desktop requires the use of the NT ID, whereas in the browser applies security using the UPN (email address).

alexhauge Frequent Visitor
Frequent Visitor

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

I just sumbitted feedback on ideas.powerbi.com requesting that this feature be restored.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20556391-please-bring-back-test-a...

 

Thanks,

 

Alex

Super User
Super User

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

Hi @tsf

 

You are indeed correct that it can use the NT User ID, it does depend on how you log into your PC. Generally most of them would be NT User ID, which would change to the UPN when in the Power BI Service


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
swise001 Regular Visitor
Regular Visitor

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

@GilbertQ Do you know if this was purposely removed or is its absence an accident or glitch?  This feature was very helpful when I needed to mirror credentials from the service - without needing to open the PBI desktop file and refresh it against updated user credentials.  

Super User
Super User

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

Hi @swise001

 

As far as I am aware it was removed so that the functionality would exist within Power BI Desktop and be able to test it there, before uploading it to the Power BI Service to ensure that it is working as expected.


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
alexhauge Frequent Visitor
Frequent Visitor

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

Hello,

 

Testing is not effective in Power BI Desktop since the roles are applied in the Power BI service and users can be members of more than one role.  How can you verify that the proper members are seeing the appropriate level of detail in the reports if you cannot view as an individual user, especially if those roles are based off of Username() DAX expressions?

 

This was an incredibly important feature and frankly I am shocked that it was deprecated.  

Moderator v-yuezhe-msft
Moderator

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

@PatrickNealis  @swise001 @tsf  @alexhauge ,

This is a known issue that engineers are working on a fix, please keep an eye on the update time in Power BI support site.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

PatrickNealis Frequent Visitor
Frequent Visitor

Re: Row Level Security "Test as role" in web browser no longer showing "view as _____

Lydia,

 

That is great news! This was a very useful feature in the online client, glad to see it will be returning. I'll keep my eye out and mark this topic as resolved when it's republished.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)