Visual Exceeding Available Resources

Hi  Anonymous ,

When you run a DAX query in Power BI it will always use a certain amount of memory; inefficient DAX calculations can cause a query to try to grab a lot of memory.

First you can try to changed the Query Memory Limit % setting :

And you can follow the tips to optimize your report：

1.Do not expose in a view a column that is not necessary in the Power BI data model.

2.Optimize the DAX calculation used in this visual effect.

3.Remove unnecessary precision or split granularity values to reduce cardinality（Significantly reduce highly unique datetime values by splitting the date and time into separate columns. ）

And also refer to https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/ 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai