Dataset refresh with service account

Hi Anonymous ,

If your datasets contain on-premises data sources, you need to add them into gateway firstly. Then configure schedule refresh.

You could reference the documents:   

Manage your data source - Import/scheduled refresh 

Manage data sources

Configure scheduled refresh 

Best Regards,

Xue Ding

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

I use service accounts for my refreshes, however i only use them as credentials for the sources themselves.  This is done either as part of the gateway's entries, or for individual cloud sources.

When you set up a schedule, you can also set up for emails to be sent to other people on failures, in case you need a ticketing system or group to action any issues.

Even if I set up a refresh, other users can "Take over" and update the refresh if required, assuming they are set up correctly in the workspace and with any gateways.

Hi Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answers as solutions if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

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

I have a similar issue. I created a CDS User Account (Azure App Registration). I can log into this account with Flow and have flow do any number of things, and that user account is added to Dynamics, uses the app client id, along with the tenant id and secret to authenticate. I would love to be able to use that account to refresh data sources, but I cannot see where this can be done. Let me know if anyone has been able to succesfully do this.

Thanks!