Forum Discussion

Alexander24's avatar
Alexander24
Helper II
8 years ago

Scheduled Refresh vs Manual Refresh

Hi there,

 

I am currently working with a client and we have noticed that when refreshing manually the refresh time is considerably faster than when doing a scheduled refresh

 

i.e Manual refresh will take 5mins, scheduled refresh will take 20mins

 

Data Source is SQL Server Data warehouse

 

Thanks

Alexander

Need Help

4 Replies

  • zoloturu's avatar
    zoloturu
    Memorable Member
    8 years ago

    Hi Alexander24,

     

    What do you mean by SQL Server Data warehouse? Is it SQL Server Analysis Services or Azure SQL Data Warehouse or just simple on-premises SQL Server?

    • Alexander24's avatar
      Alexander24
      Helper II
      8 years ago

      Hi

       

      Sorry Its a data warehouse however its just a simple on premise SQL Server from that perspective,

       

      Thanks

      Alexander

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi Alexander24,

     

    Do your mean data refresh on service or on desktop? Could you please describe more details on how did you scale the duration time?

     

    Regards,

    Jimmy Tao

    • Alexander24's avatar
      Alexander24
      Helper II
      8 years ago

      Hi

       

      I mean on the service, i.e when utilising the schedule refresh service vs triggering a manual refresh on the dataset (i.e Refresh now) -- Refresh Now only takes 5mins to refresh the dataset , whereas our scheuled refreshes can take 20 mins