Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
FrankPreusker
Advocate III
Advocate III

Power BI Desktop Version 2.118.828.0: Memory error: Memory Allocation failure . Try simplifying or r

I've just downloaded and installed Power Bi Desktop version 2.118.828.0 from Download Microsoft Power BI Desktop from Official Microsoft Download Center and now for serveral existing (larger) pbix files (with import mode data) I'm receiving this error message: 

 

Error Message:
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
An error occurred while loading Vertipaq data objects for multiple tables.

 

Not acceptable! 

1 ACCEPTED SOLUTION
FrankPreusker
Advocate III
Advocate III

In the end the solution was easy: I've noticed I've downloaded and installed the 32bit version of PBI Desktop instead of the 64bit version 😄 Switched now back and it works again on all models.

View solution in original post

3 REPLIES 3
FrankPreusker
Advocate III
Advocate III

In the end the solution was easy: I've noticed I've downloaded and installed the 32bit version of PBI Desktop instead of the 64bit version 😄 Switched now back and it works again on all models.
amitchandak
Super User
Super User

@FrankPreusker , Try to increase Cache memory management to 8-10 GB supported by RAM

 

Go to File-> Options and settings -> Options -> Security Option -> Data Load
Change Data Cache to 8-10 GB

 

Load Setting.png

Thanks for the suggestion @amitchandak 

I tried to extend the cache by multiple of 2/3/4 up to 16.384kb, but no change. Still the same. Smaller models I can open, larger ones are failing.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.