Forum Discussion
per-query memory limit issue
Resolver IIHello!
I believe that the first action in this case is to assess whether there is a possibility of optimizing your DAX calculations so that the visuals are rendered in a better way. This article by Chris Webb explains it well: The “Visual Has Exceeded The Available Resources” Error In Power BI - Chris Webb's BI Blog (crossjoin.co.uk)
As the shared capacity (PRO license) memory limit cannot be increased, it may be recommended to modify the license to Premium capacity. Premium licensing is different from PRO in that you get exclusive capacity and get consistent performance. It is worth noting that users who publish reports still need a PRO license even after migrating to the Premium license, however users who only view reports do not need a PRO license (the entire organization can access premium workspaces, but publish dashboards only who has a PRO license).
You can consult more about Power BI Premium in the official documentation: