Forum Discussion

sonm10's avatar
sonm10
Helper I
6 years ago
Solved

Different refresh for different data source in the same dataset

Hello Community,

 

I have a dataset that gets data from two different datasources (mysql db and excel file). I need to refresh the mysql datasource daily as it is updated daily. However, my excel files need to be refreshed only once a month. The excel files have some master data for the mysql data. Is there a way to schedule the two data sources independently like the mysql source daily and the excel file monthly.

Need Help
Show and Tell
Tips and Tricks
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi sonm10 ,

     

    Unfortunately,  we can't configure different refresh frequence for the same dataset. And if the files connected with import mode, we only can set refresh daily or weekly. It is not supported to configure it to month.

     

1 Reply

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi sonm10 ,

     

    Unfortunately,  we can't configure different refresh frequence for the same dataset. And if the files connected with import mode, we only can set refresh daily or weekly. It is not supported to configure it to month.