Error while publishing my direct query Dashbaord into PowerBi service

[anas_moosa]

The error is " The query result is too larde. Consider using unused columns, adding visual filter etc.."

It makes me wonder as the error is getting for one out of 5 visuals within same dataset.

And the other visuals having same data size in terms of column/row numbers numbers.

Can anyone suggest a solution. Well appreciated.

Thank you

Anas

[v-xiaoyan-msft]

Hi @anas_moosa ,

Please check Note of this article:If a table has too many values, consider converting it to a matrix and/or using drilldown. The maximum data points a table will display is 3,500.Here are some tips about Power BI performance for your reference.

You may also refer to ：

Solved: Result Query is Too Large - Microsoft Power BI Community

Best regards.
Community Support Team_ Caitlyn