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 

rohit1991's avatar
rohit1991
Super User
8 months ago

Hii Surekha_PM 

 

This error isn’t caused by your 40k rows but by the visual creating a very large intermediate join across many dimension tables, especially with calculated date tables. When too many fields from different tables are combined, Power BI can’t optimise the query and hits the “Resources Exceeded” limit. Try reducing the number of columns in the table visual, filter the date range, and avoid using calculated tables as dimensions. Once the visual has fewer cross-joins to perform, the error will disappear.