cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 373 members 3,835 guests
Please welcome our newest community members: