cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kevhav
Continued Contributor
Continued Contributor

Dataset totally stuck, cannot refresh

I have a dataset in the Power BI Service. Its data source is Amazon Redshift. It normally takes 10-15 minutes to refresh, which it does every few hours.

 

Yesterday, one refresh got "stuck." It spent several hours where in the "Refresh history" screen it said "In progress;" but on the Datasets screen in the workspace I had the yellow triangle "failure" icon (not the spinning "in progress" icon). It seemed stuck.

 

After some more time, it seemed to get un-stuck, and in the "Refresh history" screen it displayed this error message:

The refresh operation failed because it took more than 120 minutes to complete. Consider reducing the size of your dataset or breaking it up into smaller datasets.

But now, I cannot refresh the dataset, or anyting. It really is stuck!

 

Clicking "Refresh now" does nothing. (Well, for a second in the top-right corner, the "Preparing for refresh" message appears, but then nothing happens.)

 

A scheduled refresh does nothing. (And I don't get an email notification of an error; just...nothing happens.)

 

I have tried re-publishing the dataset from Power BI Desktop, to overwrite the dataset in the Service…and in Desktop I get a "Success" message...but it does not actually do anything in the service. The old "stuck" version of the dataset persists in the Service.

 

Any ideas? (I've opened a ticket with Microsoft support, but no help so far, and it's quite urgent!)

1 ACCEPTED SOLUTION
kevhav
Continued Contributor
Continued Contributor

I should have said: it normally takes around 12 minutes to refresh.

 

It never takes more than 30 minutes to refresh.

 

I opened a ticket with Microsoft support, about this.

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

HI @kevhav , did you solve your problem?

Thank you in advance.

Regards,

Matsa

kevhav
Continued Contributor
Continued Contributor

Argh, no...now that refresh that started seems to be doing the same thing it did yesterday. It has been refreshing for more than an hour. On the dataset settings page, it says "Last refresh succeeded: null." I expect I will get that "more than 120 minutes to complete" error again, after a while.

Hi @kevhav,

 

Sorry for the delay.

 

For your scenario, it seems that your dataset is very large so it will take about more than 100 minutes to refresh then you will get the error for timeout.

 

Why not try to reduce the size of your dataset or breaking it up into smaller datasets?

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kevhav
Continued Contributor
Continued Contributor

I should have said: it normally takes around 12 minutes to refresh.

 

It never takes more than 30 minutes to refresh.

 

I opened a ticket with Microsoft support, about this.

Any update @kevhav ?

kevhav
Continued Contributor
Continued Contributor

Wait, this is promising...I tried turning off scheduled refreshes, then turning them back on...and now my 8:00 a.m. scheduled refresh appears to have worked!

 

Finally, I have a new refresh "In progress." It might be fine, now.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Top Solution Authors
Top Kudoed Authors