Forum Discussion
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
Thanks Dinesh ... that explains why I was not making any progress.
My data source are csv files and I tried loading them as flat-files and via Sharepoint, but the Report Builder kept inserting PQO.
I did see some references to AS, but the links you attached look to be particularly useful. I will study then immediately.
But it is curious how straight forward it is to import a flat-file in both Desktops Apps and yet the Paginate Reports method (PQO) is completely incompatible with the on-prem server environment. I expect the flat-file source was an afterthough for Paginated Reports.