Forum Discussion
Error msg: Cannot connect to dataset with embed token because XMLA permissions are off
Objective: To embed a PBI report on a portal where the report does not require authentication or sign-in to PBI.
Have tried the below: Verified the report works directly inside the Power BI service Verified I can connect via XMLA to the composite model (XMLA read-write access provided) Ensure the service principal used by the embed application has access to both datasets Ensure the service principal used by the embed application has access to both workspaces (member access) The dataset is a composite model. The .NET code works if the dataset ID is not provided. Please share ramifications of not including the dataset ID in the code. Please help resolve this issue.
4 Replies
Hi deepti_mrl ,
what does your composite model connect to and how is it connected?
It's possible that your scenario isn't yet supported by Power BI embedded.
For example there's this limitation documented:
-
Using Power BI Embedded with datasets that include a DirectQuery connection to a Power BI datasets or Azure Analysis Services model isn't currently supported.
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
If it still does not help, please provide more details with the error.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Does this limitation include a PowerBI report connected to a Fabric Warehouse?
-
Hi deepti_mrl ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is Using Power BI Embedded with datasets that include a DirectQuery connection to a Power BI datasets still currently supported.
