Paginated Report and PQO

Hi gtux ,

Thank you for reaching out to the Microsoft Community Forum.

It is a known limitation of on‑premises Power BI Report Server (PBIRS) and Power BI Service (cloud). PQO is not supported on PBIRS, so the data extension is not registered and cannot be registered on that server.

Please try below alternative workarounds.

1. Please try to rebuild the report with a supported data source like SQL Server, Azure SQL, Analysis Services (on‑prem or Azure AS) and Power BI semantic model via XMLA (Read).

2. Create a “PBIRS-compatible” version, Cloud version --> uses PQO and for On‑prem version --> uses SQL / AS.

3. If you want to use PQO sources, the report must publish only to Power bi service.

Please refer below links.

Create a paginated report for Power BI Report Server - Power BI | Microsoft Learn

Paginated Report Data Sources in Power BI Report Server - Power BI | Microsoft Learn

Solved: Power BI Dataset and Paginated report In Power BI ... - Microsoft Fabric Community

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh