cancel
Showing results for 
Search instead for 
Did you mean: 

Maximum allowable memory allocation

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?Slow error rate.png

Status: New
Comments
Community Support

hi  @magnify-bi 

I would suggest you use directquery instead of import since your dataset is a limited number of table rows (max 1M)

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

 

and here is a document about Optimization guide for Power BI, please refer to it:

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

 

Regards,

Lin