https://community.fabric.microsoft.com/t5/Report-Server/Paginated-Report-is-blowing-up-rowcount-when-loading-Why/m-p/2911065#M27589 <P>Paginated reports just run the query you defined in dataset in your report. So this points to an issue with the query you have created. It's tricky to help further without knowing what query you are running and what your data model looks like.</P> Thu, 17 Nov 2022 01:48:32 GMT d_gosbell 2022-11-17T01:48:32Z https://community.fabric.microsoft.com/t5/Report-Server/Paginated-Report-is-blowing-up-rowcount-when-loading-Why/m-p/2909360#M27578 <P>Hi,</P><P>&nbsp;</P><P>I'm trying to build paginated reports whilst connecting to a small power BI dataset I have published in PBI server. The screenshot below shows me trying to generate a dimension table that is a single col with 65 rows, but for some reason whenever I run the report it claims to be loading a far greater amount of rows. Does anyone know how to solve this issue? It's making the entire process far too slow to be viable.&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 16 Nov 2022 11:54:00 GMT https://community.fabric.microsoft.com/t5/Report-Server/Paginated-Report-is-blowing-up-rowcount-when-loading-Why/m-p/2909360#M27578 Anonymous 2022-11-16T11:54:00Z https://community.fabric.microsoft.com/t5/Report-Server/Paginated-Report-is-blowing-up-rowcount-when-loading-Why/m-p/2911065#M27589 <P>Paginated reports just run the query you defined in dataset in your report. So this points to an issue with the query you have created. It's tricky to help further without knowing what query you are running and what your data model looks like.</P> Thu, 17 Nov 2022 01:48:32 GMT https://community.fabric.microsoft.com/t5/Report-Server/Paginated-Report-is-blowing-up-rowcount-when-loading-Why/m-p/2911065#M27589 d_gosbell 2022-11-17T01:48:32Z