Forum Discussion
Resources Exceeded
Hi! Do you have any efficient ideas on how to resolve the Resources Exceeded issue?
Thanks in advance, and happy upcoming holidays!
6 Replies
- IdrissshatilaSuper User
- Julia_MavHelper II
Hi Idrissshatila, thanks. It's Matrix already... and still the issue appears.
- IdrissshatilaSuper User
- AnonymousNot applicable
Hi, Julia_Mav
According to your description, you have encountered the Resources Exceeded issue, which usually occurs when refreshing data, loading large datasets, or performing complex calculations, you can try the following methods to resolve your problem:
- Optimize the data model by minimizing the number of columns in the table and using appropriate data types.
- Optimize DAX expressions and avoid resource-intensive functions such as EARLIER() or FILTER().
- If the problem occurs when refreshing , reasonable configuration of the scheduled refresh time ; or consider using incremental refresh strategy , only the data has been changed to refresh .
- It may also be that your local computer has insufficient content space. You can turn off the memory that is not needed in the local computer when you turn on You can turn off the memory that is not needed in the local computer when you turn on the power bi desktop.
Related Link: Solved: Service: Visual has exceeded available resources. ... - Microsoft Fabric Community
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
- AbhinavJoshiResponsive Resident
Hi Julia_Mav .
I also had this error, my isssue was I was using columns with multiple tables that had many to many relationship. I re-modelled the data to use one-many and calculative columns. It worked for me then.
I hope it helps!