Maximim allowable memory reached!

[RichFlorida]

Hello All,

While developing my report, i started getting the memory error below. Initilly it was random, now constant.

Any idea what is causing it and how to resolve it.

Thanks!

[Brunner_BI · Accepted solution]

It just seems like you have hit the memory limits and of your Analysis Services instance.

it ran out of memory, whatever calculation you ran...

[Anonymous · Accepted solution]

Hi @RichFlorida 

The error message you’re encountering indicates that the Power BI report has reached the maximum allowable memory allocation for the current Power BI Pro or Premium capacity tier you are using. Here are steps you can take to resolve this issue:

First of all, before considering an upgrade, try to optimize your report to reduce memory usage:

Reduce Data Volume: Ensure that you are only importing the data that is necessary for your reports. You can do this by filtering data before importing and you can use Power BI’s data reduction techniques like summarization and aggregation. Removing unnecessary columns from your dataset.
Optimize Visuals: Use simpler visuals that consume less memory, and avoid complex visuals that require a lot of data processing.

Use DAX Calculations Wisely: Sometimes, complex DAX calculations can consume a lot of memory. Try to simplify your calculations or use calculated columns instead of measures where appropriate.

Upgrade Your Power BI Capacity:
If optimizing the report doesn’t solve the issue, you may need to upgrade your Power BI capacity: Power BI Pro to Power BI Premium: If you are on Power BI Pro, consider upgrading to Power BI Premium, which offers more memory and resources, if you are already on Power BI Premium, you might need to move to a higher capacity tier that provides more memory.

If the report is too large, consider splitting it into smaller, more manageable reports. This can help reduce the memory footprint of each individual report.

Best Regards

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

[Brunner_BI]

Are you using Analysis Services as a data source? Just trying to understand which application is actually telling you you have reached the limit.

Generally it is most likely a data modeling / DAX problem and this is using too many resources (e.g. an inefficient calculation).

[RichFlorida]

Hi @Brunner_BI 

Yes, my datasource is an AS model.

Can you provide more insight? Thanls!

[Brunner_BI · Accepted solution]

It just seems like you have hit the memory limits and of your Analysis Services instance.

it ran out of memory, whatever calculation you ran...