RLS with Dynamic dataset binding

Anonymous — Tue, 01 Jun 2021 03:58:56 GMT

Hi Community,

I've been working with PowerBI Embedded for a few months. I managed to successfully load report in embedded view with dynamic dataset binding.

Now I have a requirement to support RLS - Row Level Security for our Analytics product. For more information about our model: we have multiple workspaces, 1 base workspace with all common reports, and multiple client specific custom workspaces, those contain client specific reports. Each workspace has a master dataset (all datasets have the same schema). We are using dynamic dataset binding for loading common reports (so common reports are used across the clients, without redefine those reports in each client/custom workspace).

I managed to get RLS working with the reports defined in the base workspace. When I tried the dynamic dataset binding with those reports, I got this error:

Dataset provided for effective identity is different from element's dataset '{guid}'

I'm not sure what I'm doing wrong, and whether RLS supports dynamic dataset binding.

Please help! Thanks in advance.

Re: RLS with Dynamic dataset binding

v-lionel-msft — Thu, 03 Jun 2021 05:48:52 GMT

Hi @Anonymous ,

Please refer to this.

Considerations and limitations

Best regards,
Lionel Chen

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

topic Re: RLS with Dynamic dataset binding in Developer

RLS with Dynamic dataset binding

Re: RLS with Dynamic dataset binding