400- Bad Request - embed token with effective identity is not supported for this datasource

[Rajesh_Rudra]

I am trying to crete Embaded token for a report, were i am geting into this issue, and it only happens in lower environments. 
The same Report Deployed to my Prod there i am able to generate the embed token just fine. 

[prasannag]

Hi @Rajesh_Rudra ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thank you.

Regards,

Prasanna kumar

[V-yubandi-msft]

Hi @Rajesh_Rudra ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft]

Hi @Rajesh_Rudra ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

Thanks..

[V-yubandi-msft]

Hi @Rajesh_Rudra ,

This error occurs when effective identity (RLS user impersonation) is not supported for the datasource in your lower environments

Datasource Authentication – Use OAuth2 or service principal authentication, as Windows authentication does not support effective identities.

Permissions – Ensure the service principal or user has "Read" and "Build" access to the dataset and workspace.

API Request Validation – Compare workspace & dataset IDs between lower environments and production.

Effective Identity Usage – If the lower environment API request includes effectiveIdentities, try removing it if RLS is not required.

Generate an embed token in Power BI embedded analytics - Power BI | Microsoft Learn

DirectQuery & XMLA Endpoint – If using DirectQuery, enable XMLA endpoint (Read-Only or Read-Write) in the Power BI portal.

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