Forum Discussion

Ritesh_Air's avatar
Ritesh_Air
Icon for Post Patron rankPost Patron
4 years ago

Row level security for Paginated report

Hi,

I have a paginated report which is using Power BI dataset as source. Some users complain that they can't see data in the report. How do I check or impersonate it in Paginated report, the way we can impersonate Power BI reports?

Thanks in advance,
RK

Need Help

4 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Ritesh_Air 

     

    I have tried in power bi service, but there is no selection to configure the security as other datasets to set RLS. You can suggest an idea on this web .https://ideas.powerbi.com/ideas/

    If possible, you can try to set a parameter in the Paginated report and this parameter as username. The username is passed into the report as a parameter. i will test if it possbile and reply you later.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

  • Ritesh_Air's avatar
    Ritesh_Air
    Icon for Post Patron rankPost Patron
    4 years ago

    Hello v-chenwuz-msft 

     

    If you can check the username piece on the paginated report and let me know how it works then I can try it my end. Thanks for your help.

     

    RK

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi Ritesh_Air 

      I have done this.

      1 add a new table with username piece field and set a parameter. paremeter's available values get from new table.

      2 go to fact table and set the filter, replace the @UserID was used as rule of RLS.

      3 select a value for parameter and view the report

      You can refer this way and do some change depend on your case.

      Best Regards

      Community Support Team _ chenwu zhu

       

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