The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Everyone,
We have a semantic model created in workspace (with RLS implemented) and a Paginated report created out of it, after embedding the report we see the RLS working fine when the user logins to the application the report sutomatically gets filterd to its respective data, But the report shows Incorrect User name as higlighted below, However In the workspace and Report server the username displays as expected
Hi @ravsha85 ,
This can happen due to differences in how the UserID is handled between the Power BI Report Builder and the Power BI service.
Firstly , you must ensure that the UserID parameter is correctly set up in your paginated report. The UserID might be displayed differently depending on whether the report is run in Power BI Report Builder or the Power BI service
The format of the UserID can differ based on whether the computer running Power BI Report Builder uses Active Directory or Microsoft Entra ID.
Below is the official link will help you:
Set up row-level security in Power BI paginated reports - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.