Paginated Report and PQO

[gtux]

I have a paginate report that publishes successfully to the Cloud.

However, when loaded on on-prem PBIRS it fails with the below error.

Is there somewhere I can find if the PQO extension is or is not registered, or is not supported on this particular server?

Version1.23.9316.13987(May 2025)

• An attempt has been made to use a data extension 'PQO' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)

[gtux]

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.

[v-dineshya · Accepted solution]

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