topic Re: RLS with multiple roles not working with embedded reports in Developer

RLS with multiple roles not working with embedded reports

HMEUserAnup — Tue, 07 Jun 2022 16:30:41 GMT

Hi,

we are trying to implement RLS feature in the .net application using PowerBI embed and are trying to pass multiple roles based on which the logged in user should see the filtered report on the client side. When we are sending a single role, the reports are getting perfectly displayed, But when we are sending multiple roles (roles, users and rules which are already configured for specific report in the powerbi desktop), it shows us with the following error on to the client-side:

Following is the screenshot of the code that we have implemented at our end :

Is it possible to display the report based on multiple roles through code approach?

And if so, Is there any documentation/code example/feeds where i can look into?

Thanks,

Anup

Re: RLS with multiple roles not working with embedded reports

Anonymous — Fri, 10 Jun 2022 06:24:12 GMT

Hi HMEUserAnup,

You can refer the following links to use Row-level security with Power BI Embedded:

Row-level security with Power BI Embedded

Works with Row Level Security in Power BI and Power BI Embedded

POWER BI EMBEDDED & RLS

And the following ones are the threads which have the similar problem as yours, please review their solutions and check if they can help you resolve the problem.

Can't display the visual

Think this is it...

https://www.sqlbi.com/blog/marco/2021/06/03/setting-the-right-permissions-for-users-of-composite-mod...

you need to also grant build permission in the same way.

Tip: "Can't Display the Visual" on embedded caused by RLS role mismatch.

Please check if your Row level Security roles are matching what role your embedded applications has setup. For instance, if you have "User" as your expected role in your report, and your application attempts to apply a nonexistant role of "Account" to the report. You will get an errorf for each visualization saying: "Can't Display the Visual. See Details."

Getting "Can't display this visual" error

I actually had this error today. It was caused by another visual that had a deleted column as a filter. I guess the cross-filtering capability of visuals was generating the error.

Check all your visuals for deleted columns or measures.

Best Regards

Re: RLS with multiple roles not working with embedded reports

Anonymous — Wed, 15 Jun 2022 07:12:42 GMT

Hi HMEUserAnup ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

Re: RLS with multiple roles not working with embedded reports

Anonymous — Wed, 15 Jun 2022 07:45:28 GMT

https://docs.microsoft.com/en-us/rest/api/power-bi/embed-token/reports-generate-token-in-group#generate-a-report-embed-token-using-an-effective-identity-example

{
"accessLevel": "View",
"identities": [
{
"username": "john@contoso.com",
"roles": [
"sales"
],
"datasets": [
"cfafbeb1-8037-4d0c-896e-a46fb27ff229"
]
}
]
}