Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PatrickNealis
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
v-yuezhe-msft
Employee
Employee

@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
ToddChitt
Solution Sage
Solution Sage

Now that RLS is in the Desktop, how does one specify what ROLE a user gets assigned to in a Dataset? There used to be an optiion on the Dataset called ROLES where by you were given access to the Roles you defined in the model (via Power BI Desktop). All that is there now is a SECURITY option that tells me that RLS is moved to the Desktop.

 

How do I assign Users to Roles in Power BI web service?

 

Thanks.

v-yuezhe-msft
Employee
Employee

@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.

What is taking so long?

Hi @tmendoza 

 

It is still there and certainly working as shown below.image.png

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ 

 

So, couple of things.

 

1) That looks like the PBI workspace manager, not a report server.

2) In the report server, there is no linkage to manage datasets.

Hi there

If you are using Power BI Report Server I am not 100% sure how test for Row Level Security.

Power BI report server works very differently to the Power BI Service. I would suggest starting a new thread where you mention it is in Power BI Report Server.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi, I am not finding any information on the Power BI Support site link you provided.  Is there a timeline when the Test As Role functionality will be restored?

 

Thanks,

Josh

Hi there,

It is working for me. When going into settings, then security and click on the three dots... Next to the role name




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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.

Looks like this is fixed now 🙂

Is this working for everyone ?

I am able to View Reports as different Roles, but as soon as I move to Any Dashboard, The Blue bar disappears.

 

alexhauge
Advocate I
Advocate I

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

GilbertQ
Super User
Super User

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 Super User!







Power BI Blog

It was not good to remove this functionality. It was a useful feature.

Smiley Sad

swise001
Continued Contributor
Continued Contributor

@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.  

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 Super User!







Power BI Blog

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.  

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).

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 Super User!







Power BI Blog

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Top Solution Authors
Top Kudoed Authors