Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
narasimhuluk
Frequent Visitor

This visual has exceeded the available resources in service not in desktop

Error: 

  • More detailsResource 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 ID1a0d809a-82e6-4a2f-af8b-237ed75e0d12
  • Correlation ID265720f9-005a-3e0f-64dd-1603cde59208
  • Request ID24439381-58fd-1507-a471-8a675b205580
  • TimeThu Jun 17 2021 12:25:34 GMT+0100 (British Summer Time)
  • Service version13.0.16211.50
  • Client version2105.5.06379-train
  • Cluster URIhttps://wabi-uk-south-redirect.analysis.windows.net/

 

i am getting this error 

 

details: 

 

i can able to filter a report in desktop for a 6 months but in service i could not able to filter for 2 months

i need to filter this report for 3 months atlest in service need help 

i used to be a pro user as it is limited ubgraded to premium user now still i can not able to filter report more then a month.

its a very simple report 2 views from differnt server join in power bi model and display in table  

 

please see screen shorts:  need urget guidence or help

 

 

narasimhuluk_0-1623928998675.png

narasimhuluk_1-1623929103145.png

 

 

4 REPLIES 4
narasimhuluk
Frequent Visitor

Its not sorted , i cant change capacity its a blank , still same issue

 

narasimhuluk_0-1624439283011.png

 

v-luwang-msft
Community Support
Community Support

Hi @narasimhuluk ,

According to the official Microsoft article description:

  • Report interactions will execute DAX queries. Each DAX query consumes a certain amount of temporary memory required to produce the results. Each query may consume a different amount of memory and will be subject to the query memory limitation as described.

The following table summarizes all the limitations that are dependent on the capacity size:

TABLE 2
Capacity SKU Size in vCores Backend vCores CPU time / minute Memory per artifact* [Gb] Max memory per query* [Gb] DirectQuery\LC queries / sec *
A1\EM1 1 0.5 30 3 1 3.75
A2\EM2 2 1 60 6 2 7.5
A3\EM3 4 2 120 10 2 15
A4\P1 8 4 240 25 6 30
A5\P2 16 8 480 50 6 60
A6\P3 32 16 960 100 10 120

 

Configure workloads

Maximize your capacity's available resources by enabling workloads only if they will be used. Change memory and other settings only when you have determined default settings are not meeting your capacity resource requirements.

To configure workloads in the Power BI admin portal

  1. In Capacity settings > PREMIUM CAPACITIES, select a capacity.

  2. Under MORE OPTIONS, expand Workloads.

  3. Enable one or more workloads, and set a value for Max Memory and other settings.

  4. Select Apply.

 

Refer:https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/ 

 

Wish it is helpful for you!

 

Best Regards

Lucien

I have alrady login with pro powerbi service. but still facing same issue. 
my dax measure as mentioned bwllow:

VAR _currentAlias = SELECTEDVALUE('Detailed Fact'[Customer])
VAR _Filter = FILTER(Filter_Customer, Filter_Customer[Customer] = _currentAlias)
VAR _cbm = CALCULATE(SUMX(VALUES(Filter_Customer[Customer]), [Last Month FGH 0 Dummy]), _Filter)
VAR _count = CALCULATE(SUMX(VALUES(Filter_Customer[Customer]), [Last Month Count 0 Dummy]), _Filter)
RETURN
    IF(ISBLANK(_cbm) && ISBLANK(_count), BLANK(), _cbm + _count)
this dax calculate [Last Month Count 0 Dummy] measure based on Filter_Customer[Customer].
sumx funcation check data row wise that is why display the error.
this dax is used on filter pannel on metrix view.
can you please help me on this ...

Hi, you need Power BI Premium to do this? Not much I can do in Admin Portal with my Power BI Pro.

 

JG

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.