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 ...
Need Help
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.