Power BI Embedded - Paginated Report Visual

Hi benbellavaap,

Thank you for reaching out to the Microsoft Fabric community.

I understand that you are attempting to embed a Power BI report featuring a Paginated Report Visual using Power BI Embedded but are facing an issue where the Paginated Report Visual fails to render, although other visuals are displaying correctly. 

Unfortunately, embedding a Power BI report that includes a Paginated Report Visual using Power BI Embedded is not supported. This limitation is documented in Microsoft’s official documentation: 
Create and use the paginated report visual - Power BI | Microsoft Learn 

• Utilize the Paginated Report Embedding API to directly embed the paginated report, rather than embedding it within a Power BI report. 

         For Reference use the below link: 

         Embed a paginated report - Power BI | Microsoft Learn 

• Please ensure that the embed token includes the Report.Read.All permission, as it is necessary for reading paginated reports. 
• When generating the embed token, please retrieve the Paginated Report’s embed URL from the Power BI REST API response instead of using the Power BI report’s embed URL. 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you. 

I very much appreciate your response.  However, I do not have a shared understanding that the paginated report visual is not supported.  I'm familiar with the considerations and limitations of the paginated report visual.  Specifically, "When embedding a Power BI report that contains a paginated report visual, using the embed for your customers method, you need a service principal and a multi-resource embed token as explained in How to embed a Power BI report that contains a paginated report visual."

This suggests it is possible to embed a paginated report visual, if following the embed for customers method.  I've been following such steps, but am still encountering an issue.  

Are you suggesting the microsoft learn documentation is misleading and needs to be revised?

Thanks,
Ben

I made some adjustments to my GenerateToken Power BI REST API call and now I'm receiving a slightly different error message.  In the Power BI Embedded Analytics Playground, the paginated report visual initially attempts to render reading "Loading Report", but then fails.  Here is the link MSFT learn documentation I'm referencing as an example for the Generate Token call.

Unable to render paginated report
Connection open intermittent error while reading in Analysis Services, needs retry.
Timestamp: 2025-03-04T01:45:02.227Z
Root activity ID: 22318aac-7b4f-4f64-bf82-aa679c40e44e
Session ID: 000019bcdb074aa5b9af7b416ddea224
Tenant ID: undefined
Cluster: https://WABI-US-CENTRAL-B-PRIMARY-redirect.analysis.windows.net
Report ID: 2a5170e4-0400-42f3-b655-19b07731e9b1
Capacity ID: undefined
ReportViewerVersion: undefined

In troubleshooting, I've achieved success embedding a paginated report visual where the data was manually entered into the .rdl file.  My intent is to source the paginated report data from a Power BI semantic model, instead.  The other variable in this successful test compared to the error I'm receiving in the report I'm aiming to embed was the creation of the .rdl in Power BI Report Builder desktop app vs. the web authoring in the Power BI service.  

Some additional steps I've taken to troubleshoot:

- granted the service principal additional API permissions including: capacity.read.all, dataset.readwrite.all, paginatedreport.readwrite.all, report.readwrite.all, semanticmodel.readwrite.all, tenant.read.all

- confirmed my Fabric tenant setting allows xmla endpoints and the fabric capacity xmla endpoint is set to read write (among other service principal related tenant setting allowances)

- security group the service principal is apart is an 'Admin' for the workspace in question, as well as assigned the Fabric Administrator role

Here is the GenerateToken call script and latest paginated report visual error message i'm encountering...

curl --location 'https://api.powerbi.com/v1.0/myorg/GenerateToken' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {{value}}' \
--data '{
"datasets": [
{
"id": "{{dateset_id}}",
"XmlaPermissions": "ReadOnly"
}
],
"reports": [
{
"allowEdit": false,
"id": "{{report_id}}"
},
{
"id": "{{paginated_report_id}}"
}
]
}'

Unable to render paginated report
Connection open intermittent error while reading in Analysis Services, needs retry.
Timestamp: 2025-03-06T03:55:57.041Z
Root activity ID: 9b596914-7877-4457-9328-a1f1242c7e63
Session ID: 00001ce0028841a59070fa897c99e73e
Tenant ID: undefined
Cluster: https://WABI-US-CENTRAL-B-PRIMARY-redirect.analysis.windows.net
Report ID: 2a5170e4-0400-42f3-b655-19b07731e9b1
Capacity ID: undefined
ReportViewerVersion: undefined

Hi benbellavaap,
Could you please confirm if the issue was resolved after raising a support case? If so, we’d appreciate it if you could share the solution to help others in the community. As we haven’t heard back, we’re closing this thread. For any further issues, please raise a new thread in the Microsoft Fabric Community Forum — we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.