Memory allocation failure

[anmolmalviya05]

Hi Everyone, Im trying to open a power bi file and getting below error:

Any idea, how to resolve this?

[Anonymous · Accepted solution]

I would start building a new mode1, adding one table or query at a time, until you reach this error.

You can download DAX Studio for free and see what are the larger tables from the View Metrics in advance menu to help show the size of tables and columns.

Try reducing the size by removing unneeded columns, changing data types (whole number for decimal if column has not precision, change date/time to date if the time is not needed, etc.)

If the model size is exceeding 1GB in the Power BI Desktop, I would look at reducing the data imported while developing the model by using parameters to limit a Sales table by Date (only the last 3-4 months). This can then be deployed to the Power BI Service, and the parameters changed to import more data on the model while deployed to service.

[Anonymous · Accepted solution]

Hi @anmolmalviya05 

The error suggests that the memory allocated for your Power BI tier is not sufficient to handle the dataset refresh or operation you are trying to perform.

You can use report server to publish the file to your workspace, and try to open it in the Power BI Service.

Power BI Report Server Integration (Configuration Manager) - SQL Server Reporting Services (SSRS) | ...

Then just as 3CloudThomas post that please try optimizing your dataset by reducing its size or complexity. This can involve removing unnecessary columns, aggregating data, or using more efficient data models.

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.

[Anonymous · Accepted solution]

I would start building a new mode1, adding one table or query at a time, until you reach this error.

You can download DAX Studio for free and see what are the larger tables from the View Metrics in advance menu to help show the size of tables and columns.

Try reducing the size by removing unneeded columns, changing data types (whole number for decimal if column has not precision, change date/time to date if the time is not needed, etc.)

If the model size is exceeding 1GB in the Power BI Desktop, I would look at reducing the data imported while developing the model by using parameters to limit a Sales table by Date (only the last 3-4 months). This can then be deployed to the Power BI Service, and the parameters changed to import more data on the model while deployed to service.