Forum Discussion
Error: "Creating embed token with effective identity is not supported for this datasource"
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
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
Not sure if this is the solution, but learned a lot. Thank you for your time. Lol.