Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

0
Ilgar_Zarbali

Request for Assistance Power BI Optimization

Submitted by Most Valuable Professional Wednesday

Hello,

I occasionally encounter the following error while working on Power BI reports: *"Resources exceeded. The query has exceeded the available resources. Try filtering to decrease the amount of data requested."*

Could you please share your insights or best practices for addressing such challenges? Your experience and advice would be invaluable.

 

 

Status: Delivered

Hi  @Ilgar_Zarbali,

 

First ,you may optimize Data Model,ensure your data model is as efficient as possible. Remove any unnecessary columns and tables, and use appropriate data types. This can significantly reduce the memory footprint of your model.
Instead of working with detailed data, use aggregations to summarize data at a higher level. This can reduce the amount of data processed and improve performance.
You may also apply filters to reduce the amount of data being processed. For example, if you're only interested in recent data, filter out older data that isn't necessary for your analysis. write efficient DAX queries. Avoid using complex calculations in measures and columns that can be pre-calculated in the data source or during data load.

Second, you can use incremental refresh for large datasets. This allows you to refresh only the data that has changed, rather than the entire dataset.For very large datasets, consider using DirectQuery mode instead of Import mode. This allows Power BI to query the data source directly, reducing the memory load on Power BI.
If you're using Power BI Premium, monitor your capacity usage and manage it effectively. Ensure that your capacity is not overloaded and consider scaling up if necessary.
It' important that your data source is optimized for performance. This includes indexing, partitioning, and optimizing queries at the source.

Finally, Limit the number of concurrent users and queries. High concurrency can lead to resource contention and performance issues. You can use the Performance Analyzer tool in Power BI Desktop to identify and optimize slow visuals and queries.

 

For more you may refer to:

How to fix visual has exceeded the available resource

How to Fix “Visual has Exceeded Available Resources” in Power BI

Service: Visual has exceeded available resources

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
2 Comments (2 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
Wednesday
Status changed to: Delivered

Hi  @Ilgar_Zarbali,

 

First ,you may optimize Data Model,ensure your data model is as efficient as possible. Remove any unnecessary columns and tables, and use appropriate data types. This can significantly reduce the memory footprint of your model.
Instead of working with detailed data, use aggregations to summarize data at a higher level. This can reduce the amount of data processed and improve performance.
You may also apply filters to reduce the amount of data being processed. For example, if you're only interested in recent data, filter out older data that isn't necessary for your analysis. write efficient DAX queries. Avoid using complex calculations in measures and columns that can be pre-calculated in the data source or during data load.

Second, you can use incremental refresh for large datasets. This allows you to refresh only the data that has changed, rather than the entire dataset.For very large datasets, consider using DirectQuery mode instead of Import mode. This allows Power BI to query the data source directly, reducing the memory load on Power BI.
If you're using Power BI Premium, monitor your capacity usage and manage it effectively. Ensure that your capacity is not overloaded and consider scaling up if necessary.
It' important that your data source is optimized for performance. This includes indexing, partitioning, and optimizing queries at the source.

Finally, Limit the number of concurrent users and queries. High concurrency can lead to resource contention and performance issues. You can use the Performance Analyzer tool in Power BI Desktop to identify and optimize slow visuals and queries.

 

For more you may refer to:

How to fix visual has exceeded the available resource

How to Fix “Visual has Exceeded Available Resources” in Power BI

Service: Visual has exceeded available resources

 

Best regards.
Community Support Team_Caitlyn

Ilgar_Zarbali
Most Valuable Professional
Most Valuable Professional
Thursday

Hello,

Thank you for your explanation. I truly appreciate it.

Idea Statuses