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

[anambedoya]

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.

[AmosHersch]

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.

[anambedoya]

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.generatetokenrequestv2data...

[AmosHersch]

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

[anambedoya]

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?

[AmosHersch · Accepted solution]

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