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

[danextian]

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. 

[Kasunpathirana]

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]

Hi @Kasunpathirana

I still have more than 40G in my C drive.

[v-sihou-msft]

@danextian

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;

https://community.powerbi.com/t5/Service/An-error-occurred-while-processing-the-data-in-the-dataset-...

For more details about the internal working of VertiPaq Engine, please refer to this article:

The VertiPaq Engine in DAX

Regards,