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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
jgarciabu
Advocate I
Advocate I

visual has exceeded available resources

Hi All,

 

I've been using PowerBI for the better part of a year now. For the last month and a half or a little more, we've had annoying failures to refresh for 6 of our 14 tile visualizations. It's also inconsistent. Some days certain tiles of the 6 refresh and others they don't. The dashboard in question contains nothing more than 14 pinned single data point cards. They are simple queries made to our Azure SQL Database. On the database, all the queries run immediately with no delay. I have all my visualizations set to connect live to our Azure database. I'm at a loss for what to do. It seems like it's an issue with resources on Microsoft's servers. Here's the error I get:

 

Resources Exceeded
 
This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.
Please try again later or contact support. If you contact support, please provide these details.

 

Activity IDc7b563f3-c93d-2aa1-2784-082b8d81f234
Request IDe4c3c75a-060f-6b40-8ab0-7ed194ba10c3
Correlation ID69832fcb-c121-4ed4-ca06-89d5275e48e2
TimeThu Jan 19 2017 11:09:24 GMT-0500 (EST)
Version13.0.1700.1003

 

1 ACCEPTED SOLUTION
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @jgarciabu,

 

Yes, the issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.

 

As suggested in the error, you may need to try filtering the visual to reduce the amount of data in the result currently.Smiley Happy

 

Regards

View solution in original post

61 REPLIES 61

@cittakaro Sure. None of my DAX is too crazy and is probably pretty basic to someone who is an expert. There might be better ways to do most of what I did but it works and loads quickly so I got what I needed. 

 

This is probably one of the more complicated measures I had in my report. I used to have everything here that you see as variables written into what is now the return statement. Sorry if it seems a bit like a jumbled mess. It's essentially just a series of nested if statements. After I started using variables, the performance of the report loading visuals was almost instantaneous rather than taking upwards of 10-15 seconds just to load a matrix/table visualization, if it loaded those visuals at all. 

 

EarnedTitleLevel# = 
VAR SurveylessthanTitle = [SurveyScoreGoal]<=values(TMD[Title Sort])
var SClessthanTitle = [StatusCountGoal]<=values(TMD[Title Sort])
var TTlessthanTitle = [TurnTimeGoal]<=values(TMD[Title Sort])
var AnswerlessthanTitle = [AnswerRateGoal]<=values(TMD[Title Sort])
VAR SurveylessthanSC = [SurveyScoreGoal]<=[StatusCountGoal]
var SClessthanSurvey = [StatusCountGoal]<=[SurveyScoreGoal]
VAR SurveylessthanTT = [SurveyScoreGoal]<=[TurnTimeGoal]
var TTlessthanSurvey = [TurnTimeGoal]<=[SurveyScoreGoal]
var SurveylessthanAnswer = [SurveyScoreGoal]<=[AnswerRateGoal]
var AnswerlessthanSurvey = [AnswerRateGoal]<=[SurveyScoreGoal]
var TTGoal = [TurnTimeGoal]
var SurveyScore = [SurveyScoreGoal]
var MinSurveys = [SurveyReceivedMin]
var MinCR = [CRCountMin]
var AnswerGoal = [AnswerRateGoal]
var statusgoal = [StatusCountGoal]
var CurrentTitle = values(TMD[Title Sort])
return

if(values(TMD[Specialty])="Mainstream PS" || values(TMD[Specialty])="NY PS",
    if(isblank(TTGoal) || isblank(SurveyScore), CurrentTitle,
    if(MinCR = -1 || MinSurveys = -1,
        if(SurveylessthanTitle && SurveylessthanTT,SurveyScore,
        if(TTlessthanTitle && TTlessthanSurvey,TTGoal,CurrentTitle)),
    if(SurveylessthanTT,SurveyScore,TTGoal))),
if(values(TMD[Specialty])="Hunt PS",
    if(isblank(statusgoal) || isblank(SurveyScore), CurrentTitle,
    if(MinSurveys = -1 || [RONAgoal]=-1,
        if(SurveylessthanTitle && SurveylessthanSC,SurveyScore,
        if(SClessthanTitle && SClessthanSurvey,statusgoal,CurrentTitle)),
    if(SurveylessthanSC,SurveyScore,statusgoal))),
if(values(TMD[Specialty])="CCS" || values(TMD[Specialty])="Escalation CCS",
    if(isblank(statusgoal) || isblank(SurveyScore), CurrentTitle,
    if(MinSurveys = -1,
        if(SurveylessthanTitle && SurveylessthanSC,SurveyScore,
        if(SClessthanTitle && SClessthanSurvey,statusgoal,CurrentTitle)),
    if(SurveylessthanSC,SurveyScore,statusgoal))),
if(isblank(AnswerGoal) || isblank(SurveyScore), CurrentTitle,
    if(MinSurveys = -1,
        if(SurveylessthanTitle && SurveylessthanAnswer,SurveyScore,
        if(AnswerlessthanTitle && AnswerlessthanSurvey,AnswerGoal,CurrentTitle)),
    if(SurveylessthanAnswer,SurveyScore,AnswerGoal))))))

 

A slightly simpler example is below here. Just for a bit of context that would make the code make a bit of sense without seeing the report, on each page of this report I've added in drop down slicers that the end user can use as selectors to adjust their goals for different tiers. Each of those slicers is reading off of a simple table that just has values that range from 0-100.

TurnTimeGoal = 
var CRCount = [CR Count]
var TT = [TurnTime]
var TCGoal = selectedvalue(TurnTimeTC[Column1])
var PCGoal = selectedvalue(TurnTimePC[Column1])
var ExecGoal = selectedvalue(TurnTimeExec[Column1])
var SrGoal = selectedvalue(TurnTimeSenior[Column1])
return

if(isblank(CRCount),blank(),
if(values(TMD[Specialty])="Mainstream PS" || values(TMD[Specialty])="NY PS",
    if(TT<TCGoal,4,
    if(TT<PCGoal,3,
    if(TT<ExecGoal,2,
    if(TT<SrGoal,1,0)))),blank()))

 

Anonymous
Not applicable

Follow up:

 

Is there any update, I am sitting at client's heat and don't have any words at the visual exceed limit error at power BI service reports.

 

Can anybody help me with this?

Dear all

 

We were dealing with this issue a year and a half ago and it was an absolute pain. We had numerous conversations with the official Microsoft support at the time and, in all honesty, they couldnt help much except for advising us that the issue was our SQL Server (queriestaking more than 5 seconds...); limit the number of the visuals in a single report. In a nutshell, limit the amount of data to be fetched; make sure to put solid indexing. 

 

So:

 

1. Check the SQL query performance. End-result in Power BI depends on the performance of your backend. 

2. Further tune it with indexing. 

3. Consider having an SSAS solution of your data instead of taping on schema tables directly.

 

good luck. 

 

 

Anonymous
Not applicable

I am having the same issue!!

 

"visual has exceeded the available resources"Untitled.png

 

Can anybody help me out, I am at the on-site project and prepared 100+ reports.

Report having an issue of visual limit and no data is able to show but the report is not that much big only few measures are calculating.

 

Please, can anybody help me out?

 

bdmichael09
Helper II
Helper II

I just ran into this problem today. I modified a report that I had previously published. The original report worked completely fine. The longest load time was maybe 5 seconds. In this 2nd itteration of the report, I modified one of the measures to use some more complicated logic. I also removed some measures from the model. The data set (which is a set of excel files) is literally the exact same. I've not added anything. At first it worked just fine. I came back to it today and made 0 changes but somehow now it is saying Visual has exceeded available resources. It makes no sense. 

juresti
Frequent Visitor

I also had this issue today.

This is what I found. I had a data set with 5 years of data and a visual displaying the last 5 days of data by default.

As soon as I went to 6 days the resources are exceeded.

 

I modified my desktop PBI to 2 years then I could go past viewing over the last 6 days of data.

 

Most likely the available resoruces are (data set size + visual memory usage + calculations / queries memory usage)

 

Of course the moderators will only repeat the documentation as the solution since they are not the software developers.

"The documentation is the final answer and correct"

 

Follow up:

 

I updated my date ranges once again to reproduce the error to confirm and the resources are not exceeded anymore.

 

My test outcome was not valid. So this must be an issue within the servers since my original dataset did not reproduce the error.

 

Anonymous
Not applicable

It must be so, that you have a random number of capacity as a Pro user, and then sometimes your organization is lower the threshhold and sometimes over. Then you get errors. Go figure.

Anonymous
Not applicable

Hi

 

I have the same problem. It says in the details "The query exceeded the maximum memory allowed for queries executed in the current workload group."

 

So it refers to the Power BI service. Works fine on desktop, not when I publish this to organization.

 

denR
Advocate I
Advocate I

There are several topics where this issue is mentioned, but it looks like this one has the extensive discussion. I'd like to know what resources we're talking about. Is it CPU or memory? Is the limit on the server hosting SSAS, on the Gateway server, on the pc/laptop running Power BI Desktop/Service or is the limit on Microsofts side so that we cannot upgrade the resources that are being exceeded? If anyone knows anything about this, I would really appreciate it if you'd share it here.

ballade4
Frequent Visitor

Also having this issue. Does not make sense. Need to understand limits better as it is turning a supposedly enterprise-level tool into a bear for certain critical tasks within my relatively-small dataset.

I am having the same issues. The dataset is not huge but I do have a number of measures becasue I need the model to be dynamic. The model works on the desktop (slow but works), but in the serivce it sometimes works and sometimes crashes. Also, I have noticed that the "spinning wheel" that used to tell me if the system was still calculating, is now gone and so I have no idea when all the calculations are compleded (I assume it vanishes when a model is nearing the resource limit). It's quite frustrating becasue you start to think that the model is stuck and then all of a sudden the data in refreshes. 

 

Is this all becasue we are not signed up to Premium Capacity? Other than major corporations, who can afford Premium Capacity at $4,000/month (or more)??? And then you start looking at Microsoft's pricing model for usage you start to wonder how anyone can really understand what their monthly bill is ever going to be. I call it the "Rube Goldberg Pricing Model". Very frustrating.

Hello,

 

Would someone confirm if this is a Premium / Pro issue? Either I change my DAX or I don't know what to do. It seems that every time I upload my data I am going to see this issue. 

I just hope Microsoft bring us a solution.

 

Cheers

I got this error today. On a relatively small set of data it is only a year but there are some complicated DAX expressions on it.

 

It seems the last straw was adding a PERCENTILEX.INC in a matrix. It won't even show 1 days worth of data which is only about 20 rows in the matrix. the table itself is only 436 rows.

Rajiv
Advocate I
Advocate I

I am having the same issue. I have a function that picks the latest date and time out of 5 Mn rows. And then uses that against other rows to calculate the relative age which then becomes the basis of the period for the chosen metric. It works well on my PBIX file as my desktop has 32 GB RAM. Our On Premise Datagateway runs on a VM with 4 GB RAM. Is there a possibility that if I increase the RAM on the VM, it would work fine?

I'd be interested in this as well. We're running our data gateway on Azure. Does the memory on the data gateway even matter, given that the report is hosted in the PBI service?

jl20
Helper IV
Helper IV

I'm having the same issue in the service, but not the desktop model (which is 20MB by the way). Have been using PBI for over a year and th is is the first time I've experienced this. Please fix.

sonalivt
New Member

Hi, I am too facing this issue. I have created my report using direct query in Azure SQL Database. My table has about 445 rows and a measure with sum of all values. Even though it is showing "Visual has exceeded avaliable resources". 

Im also facing this issue...What are the exact limitations when it comes to Power BI Service? 

Anonymous
Not applicable

Yeah, any updates? Power BI Web is way too slow with a Dataset of 200MB only, it just does not suffice.

Anonymous
Not applicable

I am also having the same issue. It takes too long to load the data into the graphs.  Please help asap.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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