Scheduling the refresh of individual Data Sources at different times within a dataset

[lordmukund]

I am preparing a validations report and for that I am pulling data from 8 different sources in my Power BI report. I published this report to Power Bi service using enterprise gateway. The data sources that I have used in the report are updated at different times. So, for performing the validations, I want to automate the refresh of this dataset (of my published report) in such a way that for a given trigger only 2 Data Sources (connections) should refresh and the remaining 6 data sources should not refresh. (I want to refresh the remaining data sources with different triggers at different times as per my requirements) Currently once the dataset of the report is refreshed all the data sources within that dataset get refreshed. But I want to configure refresh of individual data sources as per the requirements independently. Please let me know how can I do this.

[dax · Accepted solution]

Hi @lordmukund , 

As I know, when we refresh data, we usually refresh datset directly, the different datasource will refresh at the same time. By the way, I don't find settings in dataset or gateway which could be used to set refresh separately.

Best Regards,
Zoe Zhi

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