Forum Discussion
Resources Exceeded Error
Hello @EsraaKamal, @rohit1991, @srlabhe and Anonymous,
I appreciate how quickly you responded and provided a solution.
I tried every solution, but none of them were able to fix the problem. This is because the problem with my data set was different. Two date tables that I was using had non-continuous dates. The data load issue was resolved after those tables were removed.
Again, thank you very much for your support, everyone.
Regards,
Surekha
I would suggest you to denormalize the dims and facts , may be try creating views out of it and use those in PBI.It seems your query is travelling across many combinations of relationships and joins and hence the error.
But how you do denormalize
Option1: Instead of having Category A, C, and D as separate tables, combine them into one (Append Queries). And ensure to have a column in this unified table called "Category" or "Type" so you we can distinguish between them in visuals.
Option2: Can merge some of dimension fields (like City Name) directly into your Fact table. This allows you to delete the relationship lines entirely as it removes the join overhead.
I hope now its clear for you Safaa
