This visual has exceeded the available resources error for very few data in Power BI

[Akash_003]

Hi All,

My Power BI is connected to data source through direct query. Not doing any calculation(DAX etc), just showcasing the output in matrix. But when I publish the dashboard, I have two filters for select dates and all dates. When I choose All dates, the Power BI throws error "This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed." But there is not much data at all(around 39000 rows) and no calculation is being done as well. 

If anybody has faced this type of issue and resolved it, please let me know on how to overcome this issue.

[Idrissshatila]

Hello @Akash_003 ,

As mentioned in this trouble shooting,the issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.

You can refer to these related post.

visual-has-exceeded-the-available-resources-error-power-bi

Visual has exceeded the avialable resources 1

visual-has-exceeded-the-available-resources2 

You also can  contact support to for better advice .

[Akash_003]

Thanks @Idrissshatila for the assist. But I am not using any calculations here to generate my dashboard view. Direct query fetches data from SQL->then loads in Power BI -> I use matrix table to represent the data. And it has 40000 rows with file size 2.6MB. Thats why I dont understand "What too much data is being pulled here"?