https://community.fabric.microsoft.com/t5/Report-Server/Paginated-report-diff-between-connecting-to-SQL-Server-Database/m-p/3013996#M35494 <P>Hi, I was creating a paginated report (a simple one for testing) and connected to the PBI dataset.&nbsp; I used the wizard each time<BR /><BR />Each time I attempt to run it, it fails, unable to create the report</P><P>&nbsp;</P><P>I then recreated the report using the SQL Server database that the PBI report is based on, and the Paginated report ran perfectly and fast.<BR /><BR />I was wondering some reasons why a report wouldn't run using a PBI dataset, but run directly against the SQL database quickly.&nbsp; The powerBI report is working well, but a paginated report isn't.&nbsp;</P> Wed, 11 Jan 2023 14:10:59 GMT TheBIGuy_PBI 2023-01-11T14:10:59Z https://community.fabric.microsoft.com/t5/Report-Server/Paginated-report-diff-between-connecting-to-SQL-Server-Database/m-p/3013996#M35494 <P>Hi, I was creating a paginated report (a simple one for testing) and connected to the PBI dataset.&nbsp; I used the wizard each time<BR /><BR />Each time I attempt to run it, it fails, unable to create the report</P><P>&nbsp;</P><P>I then recreated the report using the SQL Server database that the PBI report is based on, and the Paginated report ran perfectly and fast.<BR /><BR />I was wondering some reasons why a report wouldn't run using a PBI dataset, but run directly against the SQL database quickly.&nbsp; The powerBI report is working well, but a paginated report isn't.&nbsp;</P> Wed, 11 Jan 2023 14:10:59 GMT https://community.fabric.microsoft.com/t5/Report-Server/Paginated-report-diff-between-connecting-to-SQL-Server-Database/m-p/3013996#M35494 TheBIGuy_PBI 2023-01-11T14:10:59Z