Forum Discussion
Configuring EffectiveIdentity for "Export To File In Group" API
Alright, I've finally found out what's wrong, and I'm not sure if I want to be relieved or frustrated at the fix. It appears that had a typo in my request body. In the code above the effective identity was passed as a property with name "identity" when it should have been "identities" instead.
Hi rvp_ordix You might be missing an exact match between the RLS role name and the one configured in Power BI or the correct username format. Ensure the user has permissions on the dataset and is explicitly assigned to the RLS role. Confirm the dataset and workspace support EffectiveIdentity for RLS. Misconfigurations in any of these areas could prevent the feature from working properly.
The names of that RLS role match, I've checked that.
What would be the correct username format? To my understanding that is simply the email address of my Microsoft account. Calling USERPRINCIPALNAME() in PowerBI returns the same address.
The user has permissions in the workspace (since that user is me, and the Fabric workspace is my own) and has also explicitely been added to the RLS role.
How would I check if the workspace supports EffectiveIdentity? Is it a Fabric Workspace with a Fabric Capacity behind it, if that matters, but I wasn't aware of anything beyond that having to be done.