Request for Assistance Power BI Optimization

[Ilgar_Zarbali]

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.

[v-xiaoyan-msft]

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]

Hello,

Thank you for your explanation. I truly appreciate it.

[woldemeskeld]

log in using my organizational account replays error in connection while my internet connection still working

[woldemeskeld]

when I try to log in using my organizational account replays the error message below, still the internet connection working