Forum Discussion
Cannot connect to dataset xxxxxxxx with embed token because XMLA permissions are off
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.
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
5 Replies
AmosHerschMicrosoft Employee
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.
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
- 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
