Forum Discussion
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...
Hi there
Yes changing the setting will certainly affect other workloads in Power BI Premium.
I would suggest looking into the Premium metric App to see how the memory allocation is being used?
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-capacity
Yes changing the setting will certainly affect other workloads in Power BI Premium.
I would suggest looking into the Premium metric App to see how the memory allocation is being used?
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-capacity
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.
- 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!