PowerBI Embedded with composite model

Hi  vojtechremis ,

Based on the information provided in your error message, you first need to make sure that the workspace capacity of the dataset in which this report is located also meets the prerequisites for implementing an XMLA connection, and that the workspace XMLA connection is open:

Troubleshoot XMLA endpoint connectivity in Power BI - Power BI | Microsoft Learn

Here's another post with the exact same error report with possible solutions, check out the link:

Solved: Re: Cannot connect to dataset xxxxxxxx with embed ... - Microsoft Fabric Community

Best Regards,

Liu Yang

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

Hi, thank you very much. I was able to solve the problem by explicitly passing datasetID of parent semantic model and setting parameter xmlaPermission (in .NET implementation dataset´s IDs are being passed automatically based on ReportID). I found a bit of information in one of the threads you provided and here: Generate an embed token in Power BI embedded analytics - Power BI | Microsoft Learn.

In case of anyone else will be dealing with the same problem, I had to:

• in PbiEmbedService.cs: add parent datasetID to datasetIds before they are being passed to GenerateTokenRequestV2Dataset() method
• when calling GenerateTokenRequestV2Dataset() add xmlaPermission parameter: GenerateTokenRequestV2Dataset(datasetId.ToString(), xmlaPermissions: XmlaPermissions.ReadOnly). Here I had to use newest PowerBI API (4.20.0).