Embedding Power BI Report with MySQL using service Principal

[Anonymous]

Hello,

I am embedding Power BI Report to the website using MySQL Database residing in AWS Cloud.

I am getting the error below:-

400 Bad Request: Error while retrieving embedded token.

Creating an embedded token for accessing the dataset requires an effective identity to be provided.

Does anyone has the idea to solve this issue.

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

Please troubleshoot according to the articles below,

Troubleshoot Power BI embedded analytics application - Power BI | Microsoft Docs

Best practices for faster performance in Power BI embedded analytics - Power BI | Microsoft Docs

Best Regards,

Community Support Team _Tang

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

[Anonymous]

Hello,

I couldn't find the solution.

I have some observations if I create a report from a dataset of MySQL and embed it using service principal, I get an error message as below.

400 Bad Request: Error while retrieving Embed token
Bad Request: {"error":{"code":"InvalidRequest","message":"Creating embed token for accessing dataset {dataset id} requires effective identity to be provided"}}
RequestId: 2fabd77d-2d56-4479-a625-1d7f0959c65a

And if I run the get dataset API with the mentioned dataset (it requires effective identity)

{
"isRefreshable": true,
"isEffectiveIdentityRequired": true,
"isEffectiveIdentityRolesRequired": true,
"isOnPremGatewayRequired": true,
}

And if I upload a sample report from the same workspace with a different dataset it doesn't require effective identity. Refer below.

{

"isRefreshable": true,
"isEffectiveIdentityRequired": false,
"isEffectiveIdentityRolesRequired": false,
"isOnPremGatewayRequired": true,
"targetStorageMode": "Abf",

}
Also, I have tried to do it with Row Level Security. It still doesn't work.

Do we need to enable some settings in the Power BI Desktop?