Forum Discussion
Super UserCreate Relationship: There's not enough memory to complete this operation.
Hi All,
Need your help again. I'm trying to create a relationship between a date column and another date column from a calendar table but PBI desktop gave me this error
Create Relationship: There's not enough memory to complete this operation. Please try again later when there may be more memory available.
Already tried this:
- Restarted my laptop.
- Cleared PBI's cache.
- Created calendar table from DAX and PQ and then tried re-creating the relationship.
I could successfully create a single direction relationship between the two columns sans the error but I need it to be both.
3 Replies
KasunpathiranaAdvocate IV
I also encounter in some times this case. Then tried having more space in C drive it worked for me. Have you tried this.
- danextian
v-sihou-msftMicrosoft Employee
Firstly, please check if your .pbix exceed the 1 GB limitation. And check the memory usage of Power BI Destop.
Then try to remove unnecessary calculated columns to reduce the memory usage of underlying engine data compression. Please see a similar thread below;
For more details about the internal working of VertiPaq Engine, please refer to this article:
Regards,
