Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Anonymous ,

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-e634-4497-afb8-20e7e9ddaf26&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

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-e0de-45cc-8744-57b972a135a5&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

 

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.