topic Re: Error: "Creating embed token with effective identity is not supported for this datasource&q in Developer

Error: "Creating embed token with effective identity is not supported for this datasource"

pauljevans — Wed, 18 Jan 2023 16:57:52 GMT

Embedding for our customers, and one of them is now getting this error on a few on their client workspaces.

And here's the dataset in question... Telling us to do Effective Identity. Unsure what is going on.

Re: Error: "Creating embed token with effective identity is not supported for this datasource&q

pauljevans — Wed, 18 Jan 2023 16:58:46 GMT

Reports do come up just fine in their power bi web portal

Re: Error: "Creating embed token with effective identity is not supported for this datasource&q

AmosHersch — Thu, 19 Jan 2023 07:14:29 GMT

Hi @pauljevans I think that the error message might be misleading. AFAIK this error refers specifically to the identityBlob (token) property of the effective identity. The rules for this property are as follows:

1. If your model is AS on-prem or Azure AS - you must not provide identity blob

2. If your model is in Power BI dataset - you must provide identity blob if you have SSO enabled, since that's the token Power BI will use for connecting to the data source - Is it posible you have SSO enabled, but you didn't provide the identityBlob to connect to the data source?

Re: Error: "Creating embed token with effective identity is not supported for this datasource&q

pauljevans — Thu, 19 Jan 2023 13:50:41 GMT

Good info to know thank you. We are not setting up identity blob, it's a "app owns data" setup using B2C local logins to auth users.

After working with the data person, dataset has data source mix of DataFlows (legacy), DataFlows, and azure SQL

Re: Error: "Creating embed token with effective identity is not supported for this datasource&q

AmosHersch — Thu, 19 Jan 2023 14:09:29 GMT

My guess - your Azure SQL is configured with SSO enabled.

In "app owns data" scenario Power BI only has the embed token, which can't be used to access the data source.

You should either turn off SSO through Power BI portal, or if you wish to keep SSO enabled then in generate embed token request provide the token for accessing the data source in "identity blob" property

Re: Error: "Creating embed token with effective identity is not supported for this datasource&q

pauljevans — Thu, 19 Jan 2023 14:45:16 GMT

Not sure if this is the solution, but learned a lot. Thank you for your time. Lol.