The Query is too Large

[Anonymous]

Hi All,

I have a power bi report that is pulling data via SQL server (direct query) and is working fine when used in the Power BI app. When I view this report on Power BI desktop all visuals work apart from one and I receive the below error;

"The query result is too large. Consider removing unused columns, adding visual filters, or reducing the number of string type columns."

My data set is not particularly large and I do not want to do any of the above-mentioned steps, I also find it weird all other visuals are working just fine and are coming from the same data set.

Any ideas on how to resolve this?

Many thanks,

E

[v-kelly-msft]

Hi @Anonymous ，

Check the similar thread below:

https://community.powerbi.com/t5/Service/The-query-result-is-too-large/td-p/618659

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , can use sql server profiler and check the query.

refer

https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages

try query reduction

https://www.youtube.com/watch?v=4kVw0eaz5Ws