Create Relationship: There's not enough memory to complete this operation.

Question

Hi All,&nbsp;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&nbsp;&nbsp;Create Relationship: There's not enough memory to complete this operation. Please try again later when there may be more memory available.&nbsp;Already tried this:Restarted &nbsp;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.&nbsp;&nbsp;

v-sihou-msft · Answer

danextian
&nbsp;
Firstly, please check if your .pbix exceed the 1 GB limitation. And check the memory usage of Power BI Destop.
&nbsp;
Then try to remove unnecessary calculated columns to reduce the memory usage of underlying engine data compression. Please see a similar thread below;
&nbsp;
https://community.powerbi.com/t5/Service/An-error-occurred-while-processing-the-data-in-the-dataset-in/td-p/158999
&nbsp;
For more details about the internal working of VertiPaq Engine, please refer to this article:
&nbsp;
The VertiPaq Engine in DAX
&nbsp;
Regards,

kasunpathirana · Answer

I also encounter in some times this case. Then tried having&nbsp;more space in C drive it worked for me. Have you tried this.

danextian · Answer

Hi&nbsp;Kasunpathirana&nbsp;I still have more than 40G in my C drive.

Forum Discussion

Related content

Not enough memory to complete this operation

Relationship

Relationships

Relationship Issue

Expression.Error: There weren't enough elements in the enumeration to complete the operation