Forum Discussion

kevhav's avatar
kevhav
Icon for Continued Contributor rankContinued Contributor
8 years ago
Solved

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 spe...
Need Help
  • kevhav's avatar
    kevhav
    7 years ago

    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.

kevhav's avatar
kevhav
Icon for Continued Contributor rankContinued Contributor
8 years ago

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.

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    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

    • kevhav's avatar
      kevhav
      Icon for Continued Contributor rankContinued Contributor
      7 years ago

      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.