Forum Discussion
Result Query is Too Large
I have a report I am trying to refresh in Power BI Service and I am getting the following error: "The query result is too large. Consider removing unused columns, adding visual filters, or reducing t...
We finally got this resolved. To fix it, we created views of the SQL Server tables used in the report. The views restricted the number of rows and columns considerably. We then used these views as the datasources for the report and it refreshes online without any issues.
We finally got this resolved. To fix it, we created views of the SQL Server tables used in the report. The views restricted the number of rows and columns considerably. We then used these views as the datasources for the report and it refreshes online without any issues.