Forum Discussion
Helper IDax Measure too heavy
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:
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.
2 Replies
- amitchandak
Super User
ErickReiis , Please share the error in text format. Also, share the measure
v-jingzhangCommunity Support
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.
