Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Data refresh: timout expired randomly

Hello,

I have created several power bi reports (related to dynamics data) in which I have activated scheduled update.
In most cases the data takes 20-30min to update, however some times (randomly) the data takes more than 2 hours which results in the update failing.

 

Do you have any idea about the cause of this problem and the possibility to solve it?

Thanks!

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    needs more details. Shared capacity or Premium?  How busy is the capacity?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I do not have a premium capacity. I have a pro license.

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Anonymous 

     

    Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider refactoring the large dataset into multiple smaller datasets.

     

    Please refer to the following link, hope it can help you.

    https://community.powerbi.com/t5/Service/Refresh-Failing-Timeout/m-p/331492#M37645 

    https://community.powerbi.com/t5/Service/PowerBI-data-refresh-failures/td-p/2293094 

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi v-zhangti,

      I have already reduced my base, but this just changes the average update time (my updates used to last more than 1 hour and now I'm down to about 20 minutes). What I don't understand are the exceptions that happen ramdomly that exceed 2 hours.