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: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

0
marian_trusik

Resources Exceeded

Submitted by on ‎01-23-2023 02:15 PM

Recently I've started to experience a problem with one of my reports.

 

Error: Resources Exceeded 

Details:

More details: Resource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. To run this query, you could simplify the query or its calculations, or reach out to your capacity administrator to see if they can increase the per-query memory limit. More details: consumed memory 1331 MB, memory limit 1331 MB. Learn more, see https://go.microsoft.com/fwlink/?linkid=2159752.
Activity ID: 2192b3c6-1b05-4845-8a1a-703a475ed06a
Correlation ID: 3f74f2a6-25b1-c608-14e1-b6a307ed37e7
Request ID: 84d457b0-1f02-4901-8c52-e24c9ccfedc4
Time: Mon Jan 23 2023 23:08:26 GMT+0100 (Central European Standard Time)
Service version: 13.0.19773.65
Client version: 2212.4.11755-train
Cluster URI: https://wabi-west-europe-e-primary-redirect.analysis.windows.net/


Problem is, that my datasets haven't grown recently. And to be honest - biggest table has 37K of rows (and 28MB total size). So I really don't understand why I got this error.

I've tried to reduce datasets (roughly by 50%) and still got this error. Which is totally non understandable to me.

And as I said - this started to happen only today.

 

One more thing - I really couldn't find a way how to report bug here, the only thing I found is "suggest idea" page. So I apologize 😉

 

Thanks!

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎01-23-2023 08:04 PM

Hi @marian_trusik ,

 

According to the documentation：

This visual has exceeded the available resources.

This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.

Your visual has attempted to query too much data for us to complete the result with the available resources. Try filtering the visual to reduce the amount of data in the result.

 

And you can follow the tips to optimize your report：

1.Do not expose in a view a column that is not necessary in the Power BI data model.

2.Optimize the DAX calculation used in this visual to use less memory and return faster or change what the visual displays.

3.Remove unnecessary precision or split granularity values to reduce cardinality(Significantly reduce highly unique datetime values by splitting the date and time into separate columns. )

4. 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 the power bi desktop.

 

This is the related document, you can view this content:

The “Visual Has Exceeded The Available Resources” Error In Power BI

Visual has exceeded the available resources - Table Visual

Data Import Best Practices in Power BI

 

You may also refer to :

Solved: Resources Exceeded - Microsoft Power BI Community

Solved: Error: Resource Governing - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

Idea Statuses