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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
erenaltun
Regular Visitor

Not enough memory error because of the data model

Hi Everyone, 

 

I have two tables which are called Email and Blocks. Email has unique segment based deliveries and Blocks has more rows for each block email has. My issue is that I'm having trouble with a matrix visual which is not possible to display the visual because of the memory (even with 10 GB space in premium server). Dataset size is around 50 MB.

 

Email Table Structure:

245k rows and more columns than below

erenaltun_3-1636564398316.png

 

 

Blocks Table Structure:

800k rows and more columns than below

erenaltun_1-1636563963357.png

 

I use CommonKey to create relationship and I also have a Region and calendar table to map dates and regions. What I want to achieve is EmailTitle, Date, Country and Block Name based metrics as below:

 

erenaltun_2-1636564327048.png

 

But it gives me out of memory error and I think

 

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

If you have a dimension table for EmailTitle and a date table for Date and you use the columns from these dimension tables in your visual, then I wouldn't expect memory issues.

 

In general, it's not a good idea to create relationships between fact tables like you've done here. I'd recommend removing that relationship and constructing your visual with dimension table columns instead.

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @erenaltun ,

1. Please kindly check how much RAM and CPU Power BI is taking. And refer the official document to optimize the data model.

Hope these help:

https://community.powerbi.com/t5/Power-Query/How-to-Optimize-Memory-Usage/td-p/57915

https://community.powerbi.com/t5/Desktop/Coundn-t-load-the-data-for-this-visual-There-s-not-enough-m...

2. You can download and install Dax Studi for query, display the content on the "All queries" page, find the query with the longest running time and analyze it:

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=6cd37af6-...

3. You can also try head to "Data Cache Management Options", clear cache or increase the "maximum allowed" figure.

 

This is the related document, you can view this content:

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=aa5e34b8-...

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AlexisOlson
Super User
Super User

If you have a dimension table for EmailTitle and a date table for Date and you use the columns from these dimension tables in your visual, then I wouldn't expect memory issues.

 

In general, it's not a good idea to create relationships between fact tables like you've done here. I'd recommend removing that relationship and constructing your visual with dimension table columns instead.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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