How can I solve this error message on a chart? "The resultset to an external source..."

[ERing]

I'm using a Direct Query connection to tables in Snowflake. The tables in my data source were recently expanded to include a wider date range and now I'm getting this error in a few of my charts.

The charts are clustered bar and line charts.

Is there anyway I can solve this?

[Uzi2019]

Hi @ERing 
You are getting this error because of huge dataset. Every visual has its limited capacity to load the data. 
As a suggestion , you may need to try filtering the visual to reduce the amount of data in the result currently.

Also try this solution this might be an issue.

If my post helps please give kudos and accept it as a solution!
Thanks

[ERing]

@Uzi2019 Would removing uneeded columns help this issue? Or is this an issue with the number or rows in my table and not the number of columns?

[Uzi2019]

Hi @ERing 
Yes try to remove single single element from chart. I cant say whether it is too much columns or too much row.

If there is too many columns in a chart then try to remove the columns from same chart and add it to other new charts.

If there is too muny rows then try to filter the data by using slicer of page or apply visual level filter on chart.

Sometimes changing the datatype from datetime to date seemed to resolve the issue.

Please try all above solution to understand the where issue is.

[amitchandak]

@ERing , Use a filter on the visual, or change the measure, Try that measure do not use row-level calculations

refer

https://www.sqlbi.com/articles/tuning-query-limits-for-directquery/