topic Re: PowerBI Report integration - Dataset ID missing for Paginated Report in Report Server

PowerBI Report integration - Dataset ID missing for Paginated Report

Gautam_Sharma — Fri, 07 Jun 2024 15:17:21 GMT

Hi Everyone,

We have successfully integrated PowerBI reports into our Java Web Application, and the reports are rendered on the webpage without issues.

However, for reports of type "PaginatedReport," we encounter a problem. The DatasetID is missing in the Get Report Endpoint (https://api.powerbi.com/v1.0/myorg/groups/<Sample-ID>/reports/<Report-ID>), which prevents us from obtaining the EmbedToken and causes the entire report rendering process to fail.

Is there a way to generate an EmbedToken without the DatasetID? Please advise.

Re: PowerBI Report integration - Dataset ID missing for Paginated Report

lbendlin — Fri, 07 Jun 2024 17:32:18 GMT

You may have to consider using regular reports that only consist of paginated report visuals

Re: PowerBI Report integration - Dataset ID missing for Paginated Report

Gautam_Sharma — Fri, 07 Jun 2024 17:56:34 GMT

lbendlin Thanks for prompt support.
We have PaginatedReport embeded inside PowerBI report so we are able to see the powerBI report but not the PaginatedReport embeded inside.

Please note we are using ServicePrinciple mechanism to embed our reports in WebApp.

Also I am adding URL which shows 403 while rendering report.

https://XXXXXX.analysis.windows.net/explore/rdlReports/<Report-ID>/session 403

{
"error": {
"code": "PaginatedReportEmbedForbidden",
"pbi.error": {
"code": "PaginatedReportEmbedForbidden",
"parameters": {},
"details": [],
"exceptionCulprit": 1
}
}
}

Re: PowerBI Report integration - Dataset ID missing for Paginated Report

Gautam_Sharma — Tue, 11 Jun 2024 13:41:17 GMT

Can Anyone please share some pointers