topic Re: Cannot connect to dataset xxxxxxxx with embed token because XMLA permissions are off in Developer

Cannot connect to dataset xxxxxxxx with embed token because XMLA permissions are off

anambedoya — Fri, 17 Feb 2023 20:15:51 GMT

I'm trying to generate an embeded token for a Paginated Report but I keep getting the error

Unexpected HTTP exception: {"error":{"code":"InvalidRequest","message":"Cannot connect to dataset xxxxxxxxx with embed token because XMLA permissions are off"}}

I'm under a PPU trial and I see the XMLA option turned on in the admin settings. Do I need additional permissions to perform this operation?

Note: The dataset linked to the report is a sample one generated in the PowerBI portal, I tried creating a manual dataset using Excel to test but it's not working either.

Re: Cannot connect to dataset xxxxxxxx with embed token because XMLA permissions are off

AmosHersch — Sun, 19 Feb 2023 12:31:22 GMT

Hi,

Did you see this example: Embed Token - Generate Token - REST API (Power BI Power BI REST APIs) | Microsoft Learn for generating an embed token for a paginated report which has a Power BI Dataset as a data source? In particular you should have the dataset ID in the list, and add "xmlaPermissions=true" for the dataset.

Re: Cannot connect to dataset xxxxxxxx with embed token because XMLA permissions are off

anambedoya — Mon, 20 Feb 2023 16:12:19 GMT

Hi, I tried to add it as you mention but that property is not available in the GenerateTokenRequestV2Dataset class so I can only send the id https://learn.microsoft.com/en-us/dotnet/api/microsoft.powerbi.api.models.generatetokenrequestv2dataset?view=azure-dotnet

Re: Cannot connect to dataset xxxxxxxx with embed token because XMLA permissions are off

AmosHersch — Mon, 20 Feb 2023 16:31:37 GMT

Hi,

Not sure why but the docs you see are for older version of the .Net SDK which is pretty old, and doesn't include xmlaPermissions parameter.

The latest version is 4.11.0 which does include it. Nuget is here: NuGet Gallery | Microsoft.PowerBI.Api 4.11.0

Re: Cannot connect to dataset xxxxxxxx with embed token because XMLA permissions are off

anambedoya — Mon, 20 Feb 2023 16:34:52 GMT

Thanks for the reply! It just worked for me from postman, I'll update that later... now, this is the embeded paginated report but it's asking me to log in to Power BI, do you know if it's possible not to ask the user to log just like in normal reports?

Re: Cannot connect to dataset xxxxxxxx with embed token because XMLA permissions are off

AmosHersch — Tue, 21 Feb 2023 07:20:02 GMT

In "Embed for your customers" (AKA App Owns Data) scenario you're not suppose to see any sign-in page/dialog. Only in secure embedding scenario (Embed a report in a secure portal or website - Power BI | Microsoft Learn) you should see it.

What is the report embed URL you are using? If it contains autoAuth=true then it's for secure embedding. In your scenario it shouldn't have it, and just look like this:
https://app.powerbi.com/rdlEmbed?reportId=0c1af178-5ab5-4a57-b4ab-feb8586dxxx&config=eyJxxxxxxxx