Forum Discussion

sqlguru448's avatar
sqlguru448
Icon for Helper III rankHelper III
6 years ago

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 h...
Need Help
Tips and Tricks
sqlguru448's avatar
sqlguru448
Icon for Helper III rankHelper III
6 years ago

Thank you for the quick response, currently the Max Memory of Paginated reports is set to 20%.

 

By changing the Max Memory of Paginated reports will it impact any other settings? or will decrease the memory allocation for reports/dashboards which are created in Power BI? 

  • sqlguru448's avatar
    sqlguru448
    Icon for Helper III rankHelper III
    6 years ago

    Thank you.

     

    I have checked the app, it's using the full allocated memory for paginated reports, I cannot increase it since it will impact other work loads. please suggest.

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      6 years ago
      Hi there

      It would appear to run your query you will need more memory.

      The only alternative other than more memory is to reduce the number of columns, rows or both!