Forum Discussion

Surekha_PM's avatar
Surekha_PM
Resolver I
8 months ago
Solved

Resources Exceeded Error

Hi Everyone, I am using a star schema where one table is connected with 6 tables. There are also 2 calculated tables, which are the split of another table to check two different categories. There ...
Need Help
  • Surekha_PM's avatar
    Surekha_PM
    8 months ago

    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 

EsraaKamal's avatar
EsraaKamal
Kudo Kingpin
8 months ago

Hi Surekha_PM ,

 

The "Resources Exceeded" error on a dataset of only 40,000 rows confirms that this is not a data volume issue, but a Data Modeling issue. Even with millions of rows, Power BI usually handles star schemas easily. When it crashes on 40k rows, it is almost always due to "Table Ambiguity" or "Bi-directional Filtering" causing the engine to run a calculation that spirals into infinity (a massive Cartesian product).

 

Steps to resolve:

  1. Strictly enforce Single Direction filters: Change all relationships to "Single" (One-to-Many) where the Dimension filters the Fact table.
  2. Fix the Duration Table: Remove the Many-to-Many relationship if possible.
  3. Hide Unused Keys: In the report view to prevent accidental usage in visuals, which can trigger bad query plans.

 

Hope this helps