Forum Discussion
PowerBi Embedded API Works with RLS!
FYI. I was able to figure out my issue. Previously, the report was shared with the master user account. This situation required the EffectiveIdentity in the embed token to have the master user username. We couldn't use it for dynamic RLS. Then we moved the report to a workspace for which the master user is an admin. After that, the username could be used for dynamic RLS (i.e., username could contain a value other than the master user username). So that was the difference. Shared reports couldn't use dynamic RLS.
Helper VWe have had similar issues in the past using RLS within the REST API.
We are using the API in a "User Owns Data" model. When we open the report we want that report to auto filter using the RLS identifier that we pass to the openinfg the report via the API.
It would seem this is what you are saying you have achieved. In my testing I am the only user account involved. Report is published to my Workspace - so I am an admin.
Could you possibly paste in some code extracts within your API of your call to the report and how youy past the RLS name ? Thanks in advance