cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
o59393
Post Prodigy
Post Prodigy

Not enough memory to create relationship

Hi all

 

I am trying to do a relationship (one to many) for a date field.

 

One table (date) contains the days of the year since 2017 (1194 rows) , and the other table (called query1) contains 830,000 rows with a column date.

 

 I got this message:

 

query1.png

 

How can i fix this?

 

thanks.

1 ACCEPTED SOLUTION

hi @parry2k 

 

It just worked, I did first the relationship from date to query1 first, and then from date to formula.

 

dateeee.PNG

 

Thanks for the help 😄

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User IV
Super User IV

I'm with @parry2k that seems odd. How much memory do you have? You could try to turn off the automatic date hierarchy in File | Options and settings | Options. I have seen that blow up some data models because every date is unique.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Hi @Greg_Deckler 

 

The file size is 62 MB, I have the PBI pro version. In the end worked, by just doing the bridge from date to query (the heaviest table), instead of table to formula.

 

Thanks!

 

 

@o59393 very odd that sequence of relationship worked. I have never see this and I'm sure @Greg_Deckler will agree on this with me. Really odd and infact would like to learn more on this. seems one off corner case.






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User III
Super User III

@o59393 wow never seen that. can you put these two tables in a seperate pbix , don't add any measure and try to create the relationship. 

 

Do you have many dax measures in this model?






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





hi @parry2k 

 

It just worked, I did first the relationship from date to query1 first, and then from date to formula.

 

dateeee.PNG

 

Thanks for the help 😄

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors