The current REST API endpoint for executing DAX queries on datasets that has RLS enabled, requires the permissions for the RLS roles to be configured in Power BI Service.
This is a problem for customers who use embedded capacity, because the access rights are often managed by the software itself (not power bi service) in which the reports are embedded in. When giving access rights in power bi service to RLS roles, it requires the user to be invited into the tenant of the power bi service provider, which is a no-go.
We need a way to pass an EffectiveIdentity (or similar) into the execute query endpoint so that we have the ability to choose which RLS roles are applied on the dataset for a specific user when executing the DAX query rest request.
nschachter
on:
Tags/Labels to structure all fabric content
on:
Fabric free trial