Forum Discussion

Jhu23's avatar
Jhu23
Frequent Visitor
5 years ago
Solved

How to test RLS for all reports that share a single dataset?

Hi all,   I need your help!   I have a single shared dataset that feeds 3 separate reports (A, B, and C).      Report A contains the actual dataset.   Reports B and C reference Report ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    hi Jhu23, 

     

    I tested the particular scenario and I am able to toggle between 2 reports - 1 built on the data model and another which is using the same data model as a shared dataset. 

     

    If you have assigned users to the different security groups then you would need to assign similar security at report level as well so users just see the report they need to see. 

     

    Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

     

     

     

     

Majkel's avatar
Majkel
Helper I
4 years ago

Reopening this post, as Power BI team closed this opportunity with last update of Power BI Service.

 

Do we know how RLS could be tested in shared datasets, as we cannot expand view on reports inside given workspace? 

 

LalitHCL's avatar
LalitHCL
Advocate I
3 years ago

i know of 2 options to test RLS on shared dataset. 

First, you can create a tabular visual on shareddataset pbix, containing all columns.When you deploy that PBIX you will have a report which you can use to test RLS, using RLS "test as role" functionality

Second, is by creating a embedded application (a kind of simulator), which can have input as user email and role id.