Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

ASP

No longer able to test RLS of multiple reports with a shared dataset

Submitted by on ‎03-20-2023 03:34 PM

We used to be able to test the RLS of multiple reports that shared the same dataset by going into the dataset's options --> Security --> Test as Role to view main report as a specific user.  I could then do to the panel on the left, and select a new report (that shared the same dataset), and it would allow me to view that report as the specified user as well.

 

However, starting last week, the option to select another report is no longer available. If I click on the workspace icon, it just redirects me to the workspace.

 

We really need this functionality to be brought back as there is no other way to test RLS for these reports now!

 

 

RLS Issue.png

Status: Delivered
See more ideas labeled with:
8 Comments (8 New)
Comments
Anonymous
Not applicable
‎03-20-2023 06:14 PM

Hi @ASP 

It's by design . If you feel that this change has had a greater impact on your operation, We'd love to hear your feedback at Power BI Ideas.

Ailsamsft_0-1679361246803.png

Best Regards,
Community Support Team _ Ailsa Tao

ASP
Regular Visitor
‎03-20-2023 06:44 PM

Wow.  @Anonymous , so then what is the recommended method to test that RLS is functioning properly for all shared-dataset reports?  Are there any alternatives?

 

Thank you!

 

ChristianMetzen
New Member
‎03-20-2023 11:33 PM

@ASP @Anonymous This is really a problem, with this change it is impossible to test reports based on a dataset as specific role. What is the alternative to test such reports?

bjkoning-bince
Advocate I
Advocate I
‎03-21-2023 06:13 AM

@ASP  @Anonymous same issue here ; for our functional testing and user support workflow not being able to verify reports as a user/role is really undesirable. It complicates these workflows unnecessarily. I would like to see this option return to the interface, or have an option to disable the new user experience.

ASP
Regular Visitor
‎03-21-2023 08:37 AM

@bjkoning-bince @ChristianMetzen , I created a new Power BI Idea to bring this feature back.  Please vote here if you believe it is important: Bring back ability to test RLS for multiple reports on shared dataset in PBI Service 

bjkoning-bince
Advocate I
Advocate I
‎05-24-2023 05:30 AM

I just found out that the functionality is back in another form @ChristianMetzen @ASP ; the new-new interface adds a shortcut / quick link below the current workspace to the last visited report, visible in the left menu bar. You can test as role and select the report you want to debug/test from the quick link while testing as role. The test as role option remains active as long as the report is still in the same workspace as your dataset.

dontcallmedeb
Frequent Visitor
‎07-15-2023 05:09 PM

Found this article, and the suggested steps worked for me.
https://www.linkedin.com/pulse/testing-row-level-security-power-bi-service-mads-steenstrup-hannibal/

hsantosh
Helper I
Helper I
‎03-03-2024 08:58 PM

Hi have 2 shared datasets example dataset 1 amd 2. On dataset 2 applied RLS with USERNAME(). Built report importing both as direct query and gave relationships. In service and desktop report report is working fine but in embedded application throwing error. Unexpected error something in inspect saying report token issue with workspace name. Can You help on this issue. Multiple shared datasets can't we use to build report with RLS USERNAME(). If need any more information I will share I'm details

Report is embedded in application. In application report is bot working error is coming.

This widget could not be displayed.
Idea Statuses