Dax Measure too heavy

[ErickReiis]

Hello everyone, everything good ?

I'm having problems with a calculation in DAX that is doing a projection calculation.

The calculation is not the problem but as I have a considerably large database, when I publish it it gives an error and informs that it cannot show the graph because the Resources were exceeded.

Can you tell me if in the Premium Power BI Environment there is any difference in the memory issue used for calculations?

The Problem that is happening:

[v-jingzhang · Accepted solution]

Hi @ErickReiis 

In Premium, you can adjust the workload settings for Premium capacities. You can increase Query Memory Limit in Admin Portal. Please refer to How to configure workloads in Power BI Premium - Power BI | Microsoft Docs 

Chris Webb has a blog explaining this error, here is the blog link Chris Webb's BI Blog: The “Visual Has Exceeded The Available Resources” Error In Power BI

When executing DAX queries, the whole data model is loaded into memory. So to avoid this error, one option is to increase the memory limit, the other is to reduce unnecessary data to decrease the data model size. 

Also if the DAX is too complex and has many variables or something else that may produce a lot of temporary data in memory, it may also have an influence. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@ErickReiis , Please share the error in text format. Also, share the measure