Forum Discussion
Helper IIIssue: Not enough memory, unable to create simple table visual
Super UserHey alks_skla_f ,
From the attached picture, I believe there is a data modeling issue at play. The 'case survey' table and the 'case_history' table cannot cross filter each other. Yes, they are both connected to 'case dimension' but the filtering only flows in one direction that is from 'case dimension' to each of these tables. So, Power BI will now try to create a Cartesian product which will blow out the resources (and is probably not even the result you want).
Hope it helps!
alks_skla_fHow can I fix it, please?
- alish_b
Please share a representative sample of the data (without any sensitive data) that can be copied so that we can get a general idea of the data at hand. Make sure the data demonstrates the issue (in this case, I am assuming there is a many to many scenario which made you opt for the dimension table). And also include a basic mockup of the table visual you are trying to achieve (an excel table showing what end result should look like).