Query execution failed for dataset - Paginated report

Hello Folks,

I have a paginated report published to Power BI workspace, the report runs fine for small set of data but when it outputs ~55K rows for 60 columns it gives below error, can you please help me out if any capacity settings needs to be changed without impacting other reports which are created in Power BI?   

There is no issue with gateway/dataset or the query behind the report as it runs fine on SSMS.

Any help is really appreciated.

Thank you.