Forum Discussion

Majkel's avatar
Majkel
Helper I
4 years ago
Solved

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

Hi,

 

I have a big problem. I have multpile reports build on a single dataset and currently it's only possible to test RLS on firtly created report. 

 

Assuming that I have dataset 1, I can easily test as role in firt report (A), but after developing reports B and C from the same dataset I'm not able to control what users see in these reports.

 

 

Any recommendation? In the past it was possible with this trick:

https://community.powerbi.com/t5/Service/How-to-test-RLS-for-all-reports-that-share-a-single-dataset/m-p/2728135#M170860

 

But now after the navigation panal changed, it is not longer possible to access workspace elements.

 

Thanks

9 Replies

  • Hi v-yadongf-msft ! 

     

    Many thanks for your message.

     

    Yes, indeed this solution may work, but my current problem is that after recent update in Power BI Service, I'm missing the button to extend navigation panel, so I'm not able to access workspace elements.

     

    Do you maybe know how I could extend the navigation panel?

    • GilbertQ's avatar
      GilbertQ
      Super User

      Hi Majkel 

       

      This is the new way that the Power BI Service works, you would need to click on the icon to see the relevant area.

  • Hi Majkel 

     

    As far as I know you can only test it on the 1 report.

     

    What I have done in the past is to create another user account (which I can log in with) and I then use this account to then test the RLS against other reports.

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support

    Hi Majkel ,

     

    However, as you mentioned link: https://community.powerbi.com/t5/Service/How-to-test-RLS-for-all-reports-that-share-a-single-dataset..., I can normally test dynamic RLS for all reports that share a single dataset as shown below. Did you encounter any problems when using this method?

     

     

     

    If I misunderstand your demands, please feel free to contact us in time.

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Hi v-yadongf-msft ! 

     

    Many thanks for your message.

     

    Yes, indeed this solution may work, but my current problem is that after recent update in Power BI Service, I'm missing the button to extend navigation panel, so I'm not able to access workspace elements.

     

    Do you maybe know how I could extend the navigation panel?

    • v-yadongf-msft's avatar
      v-yadongf-msft
      Community Support

      Hi Majkel ,

       

      Please click here

      Best regards,

      Yadong Fang

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.