The “Visual Has Exceeded The Available Resources” Error In Power BI Desktop

If you encounter this error when refreshing a report, it is likely your dataset is too large. The Power BI Service has finite resources so Microsoft don’t allow you to run queries there that take hours to complete or consume vast amounts of memory.

One solution is to apply a filter that reduce the amount of data being shown. 

Another one is to increase the limit in Power BI Desktop.

Go to File/Options and settings/Options to open the Options dialog, go to the Report settings pane and scroll to the bottom to see the Query limit simulations section.

You can either use the “Custom limits” option, to set your own limits (enter 0 in one of these boxes for no limits to be imposed) or use the “No query limits” for no limits. You should only use these options if your system has enough memory to handle the amount of data being shown by Power BI.