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

Error while scheduled refresh

Had a scheduled refresh kick this error back on me and do not see an explanation out there so I thought would check here:

 

The operation was throttled by Power BI Premium because there were too many datasets being processed concurrently.

 

Please advise.  Thanks

7 REPLIES 7
Highlighted
Continued Contributor
Continued Contributor

Re: Error while scheduled refresh

How many scheduled refreshes are implemented? You can also check this at sql server agent and take a look to the jobs are named with uniqueidentifiers.

Highlighted
Impactful Individual
Impactful Individual

Re: Error while scheduled refresh

Hey you're not alone at this. Same problem recently here!

Highlighted
Frequent Visitor

Re: Error while scheduled refresh

Is there a solution for this issue? 

Highlighted
Regular Visitor

Re: Error while scheduled refresh

@philipplenzThis sounds interesting. How can I access the sql server agent to view the scheduled refreshes?

Highlighted
Continued Contributor
Continued Contributor

Re: Error while scheduled refresh

Hi @PaulEskes 

 

Go to the Management Studio from the sQL Server.

As a system admin you can view the SQL Server Agent Jobs

 

https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent?view=sql-server-2017

 

Best Regrads,

Philipp

Highlighted
Regular Visitor

Re: Error while scheduled refresh

@philipplenzI can imagine that data sets scheduled in the Power BI service use SQL Server agent jobs in the background to refresh the datasets. If you can get access to that agent (e.g. using XMLA) , then you can see which refreshes are scheduled at what time. If this is true and somebody knows how to get (viewing) access to that agent please let me (and the rest of the community) know.  

Highlighted
Continued Contributor
Continued Contributor

Re: Error while scheduled refresh

@PaulEskesI thought this topic regarding to the on premises report server. If you use an on prem server, the scheduling works with the SQL Agent. Power BI online has a scheduler on the cloud service

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!