cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iron_dinges
Helper II
Helper II

Visual has exceeded the available resources - new error on a known working report

Detailed error message:

Resource Governing: The memory used by the query exceeded the configured limit. The query or calculations referenced by it might be too memory intensive. Please consider simplifying the query or calculations. If the dataset is hosted on a dedicated capacity/server, you may also reach out to your capacity/server administrator to see if the per-query memory limit can be increased. Additional information: Requested 1048577KB, Limit 1048576KB.

 

This is on a Matrix visual on a report that has been used for about 6 months without issues.

No changes have been made to the report.

 

When I add a slicer and filter the data, it renders correctly.

 

The matrix is fairly large, it contains 4 "Rows" and 6 "Values". However as stated above, this matrix has been working fine for months.

The expected behaviour is that even though the data set is large, the visual loads the first 1000 rows, and continues loading as you scroll down.

 

Has something recently changed on the Power BI service regarding resource limits?

This is on a Power BI Pro license.

 

EDIT: Just to add, I have tested this on Power BI Desktop, where it works as expected. This issue is only in Power BI Service.

1 ACCEPTED SOLUTION
iron_dinges
Helper II
Helper II

After investigating further, it seems it was a change made a few weeks ago to one of the measures. Issue resolved.

Measure was changed from min(sum() + measure, sum()) to if(sum() + measure > measure, sum(), sum() + measure), which does use much more resources.

Apologies!

View solution in original post

1 REPLY 1
iron_dinges
Helper II
Helper II

After investigating further, it seems it was a change made a few weeks ago to one of the measures. Issue resolved.

Measure was changed from min(sum() + measure, sum()) to if(sum() + measure > measure, sum(), sum() + measure), which does use much more resources.

Apologies!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!