Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
anambedoya
Frequent Visitor

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.

anambedoya_0-1676664665578.png

 

1 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 

View solution in original post

5 REPLIES 5
AmosHersch
Microsoft Employee
Microsoft 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.generatetokenrequestv2data...

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

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?

anambedoya_0-1676910829196.png

 

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 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.