Maximum allowable memory allocation

[magnify-bi]

Hey,

I just published the report on my test env but it crashes because it consumes a lot of memory. My test databases have a limited number of table rows (max 1M).

Is it possible to optimize the report so it can handle million rows of data, error message attached.

Raising the tier is not an option as this will make the whole proposition far too expensive.

Data is currently being imported, will changing to direct query help?

[V-pazhen-msft · Accepted solution]

@magnify-bi

Check how much memory you have and how much space you have used.

According to my research, at some point this may be a temporary error.

You might have a reference to these two similar threads that have been resolved.

https://stackoverflow.com/questions/45634697/azure-analysis-services-maximum-allowable-memory-issue

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/94758523-b9fa-4567-b3d9-1759abb54a84/you-ha...

Paul Zheng _ Community Support Team
If this post helps, please accept it as the solution to help the other members find it faster.

[amitchandak]

@magnify-bi , Log an issue -https://community.powerbi.com/t5/Issues/idb-p/Issues