Table visual - Visual has exceed the available resources

[Anonymous]

Hi,

I tried to do a simple table visual (Import Mode) with few columns in PowerBI Desktop but I got the below error message.

I think there is a limitation for the visuals with maximum of 30,000 rows but I cannot reduce the number of rows by adding filters, because I want to display all the data in the table without setting any restrictions.

Is there a way to fix this or any workarounds?

Thanks.

Best regards,

Emily

[v-easonf-msft]

Hi , @Anonymous 

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. Inefficient DAX calculations can cause a query to try to grab a lot of memory.The real solution is to tune the DAX calculations used in this visual,so they use less memory and return faster or change what the visual displays..

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 .

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , Refer if this can help

https://community.powerbi.com/t5/Service/Visual-has-exceeded-the-available-resources-power-bi-premium/m-p/1047698