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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
danextian
Super User
Super User

Create 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. 

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
3 REPLIES 3
Kasunpathirana
Resolver I
Resolver I

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

Hi @Kasunpathirana

 

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










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

@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,

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.