The Query is too Large

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