Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
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?
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
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |