Query Resources Exceeded Error

Hello Raja10ram ,

you need to minimize the load, try removing complex measures from the table and make it in Power query.

Hi Raja10ram 

The "Resources Exceeded" error in Power BI typically occurs when a query or its calculations consume more memory than the configured limit. Here are some strategies to optimize your query and manage resource limitations effectively:

Simplify Your Query:

• Review and simplify your query by removing unnecessary columns, filters, or transformations.
• Ensure you're only loading the data needed for your report.

Reduce Data Volume:

• Filter your data to load only a subset, such as a specific date range or relevant categories.
• Consider aggregating or summarizing data at the source level before importing it into Power BI.

Optimize Data Model:

• Use best practices for modeling your data, such as avoiding overly complex relationships and using role-playing dimensions.
• Prefer calculated tables over calculated columns when possible.

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz