Hi, @GovindPrajapat
The "Resources Exceeded" error in Power BI usually indicates that the amount of memory or processing power allocated to your data model is not sufficient to handle the amount of data being loaded. Here are a few suggestions that might help:
- 1. Optimize your data model: Make sure that your data model is optimized for performance by removing unnecessary columns, creating relationships between tables, and using calculated columns instead of DAX expressions. You can also try using incremental refresh to load only the new or updated data.
- 2. Use a dedicated data source: If possible, use a dedicated data source for Power BI to improve performance. This can be a SQL Server database, a data warehouse, or a cloud-based data source like Azure SQL Database or Amazon Redshift.
- 3. Upgrade to a higher SKU: If your current SKU is not providing enough memory or processing power for your data model, consider upgrading to a higher SKU. The higher SKUs provide more memory and processing power, which can help with loading and refreshing large data models.
- 4. Increase the memory allocation: If you are using Power BI Desktop, you can try increasing the amount of memory allocated to Power BI. You can do this by going to the "Options and Settings" menu, selecting "Options," and then selecting "Memory Management." From there, you can increase the "Maximum Memory" setting.
- 5. Check for memory leaks: Memory leaks can occur when a program does not release memory that is no longer needed. Check your code for any memory leaks that might be causing the issue.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
