Error: Resource Governing

[DMSJennifer]

Hello,

I'm trying to load some data into my visual, but when I want to view a lot of data, my visual shows the following error:

• More information: 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. Either reach out to your Analysis Services server administrator to increase the per-query memory limit or optimize the query so it consumes less memory. More details: consumed memory 1024 MB, memory limit 1024 MB.
• Activity-id: ********-****-****-****-9a1a7576c768
• Correlation-id: ********-****-****-****-d3241b4c4530
• Request-id: ********-****-****-****-6641a53adb33
• Time: Tue Nov 30 2021 17:02:48 GMT+0100 (Midden-Europese standaardtijd)
• Serviceversion: 13.0.17186.43

I don't have any measures in this table, and if I use filters, I get the same message. 

Does anyone has an idea on how to solve this problem or how I can find the out what the cause of this problem is?

Thanks in advance!

Jennifer

[V-lianl-msft · Accepted solution]

Hi @DMSJennifer ,

Depending on the data source and the number of fields (measures or columns), a visual may load slowly. We recommend limiting visuals to 10-20 total fields, both for readability and performance reasons.

The upper limit for visuals is 100 fields (measures or columns). If your visual fails to load, reduce the number of fields.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vishal097]

Hello @V-lianl-msft 

Does calculated coloum also can cause this error ? 

[amitchandak]

@DMSJennifer , if you are a premium customer you can use you can install capacity app

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-capacity

or you can use SQL server profile to monitor the queries

refer

https://blog.crossjoin.co.uk/2020/03/02/connecting-sql-server-profiler-to-power-bi-premium/

[DMSJennifer]

And what are the options if you're a pro user? Is the only solution a premium account or are there some workarounds to solve this problem?