Forum Discussion

Kasunpathirana's avatar
Kasunpathirana
Icon for Advocate IV rankAdvocate IV
7 years ago

Power BI Service Refresh took more than expected time

I have one issue where the refresh usually starts at 7 p.m. and ends at 7:15 p.m. or earlier.

 

But suddenly there was a change it started as usually 7:01 p.m. but ended it on 9:00 p.m.. 

 

I want to know what are the reasons for this and what is the usual SLA committment for the refresh time given it has been started.

 

2 Replies

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

    Hi Kasunpathirana,

     

    There are many factors may affect the refresh time, such as your large dataset or the network.

     

    Is your dataset online source?

     

    In addition, you could have a reference of this article.

     

    Best Regards,

    Cherry

    • Kasunpathirana's avatar
      Kasunpathirana
      Icon for Advocate IV rankAdvocate IV

      Thanks v-piga-msft for the reply. 

       

      Dataset is not so large doesn't take much time 2-3 minutes to refresh if refresh manually. 

       

      I'm using a gateway to connect to the SQL datasource. 

       

      Can help me to tell what could be the possible reasons in this case.