RLS Issue with porta integration

[sribmc]

Hi Team,

We have integrated powerbi reports with portal application.In portal application there were using apis to authenticate.Recently they have issue on authentication not able authenticate using user with viewer permission.But when we changed the user permission to member its working at portal application.

But we need to work authentication with RLS with Viewer user permission.Please kindly help on this earliest.

[Anonymous]

Hi @sribmc ,

For your question, I think we can do a step-by-step troubleshooting to be able to better help you determine what your problem is:
1. In Power BI Desktop, ensure that the appropriate roles and row-level security rules are defined for the Viewer user, and then simulate the Viewer user to confirm that the data is filtering as expected.
2. After publishing to Power BI Service for RLS validation.
Check the data source permissions first to make sure that the permissions of the data source are set to allow Viewer users to access the relevant data. Then use the View by Role feature to verify that the Viewer user can access the data.

3.3. You can use the following tools to check the API request to see the response status commonly:
The following four cases:
401: Unauthorized (may be an authentication issue)
403: Access denied (may be a permissions issue)
404: Not found (requested resource does not exist)

Troubleshoot Power BI embedded analytics application - Power BI | Microsoft Learn

I hope that the solution and documentation I have provided can solve your problem, if you have further questions, feel free to contact me, I will reply to you as soon as I receive the message!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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