Cloud and on prem data sources disabling scheduled refresh

[andyln33]

In my PBIX, I have a cloud connection and an on-prem connection. When I publish the report, I get the dreaded "Scheduled refresh has been disabled" message.

IT has setup a gateway, but apparently only they can edit credentials and schedule refresh. They're saying we have to get them to publish each and every time for this report. 

Is there a better way to do this? Is the checkbox "Allow user's cloud data sources to refresh through this gateway cluster" potentially not checked?

Any help or advice is appreciated!

[v-xicai]

Hi   @andyln33 ,

Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @andyln33 ,

The option "Allow user's cloud data sources to refresh through this gateway cluster" should be ticked, and won't be changed automatically, while it may not be the issue root. The credential of your data source may be changed according to the company security privacy or the paths of data source have be changed, for example the password of your data source may be changed monthly. So you may need to go to data source setting, update the credential via click the option "Edit credentials" for the data source.

For reference:

Troubleshooting refresh scenarios

Best Regards,

Amy 

Community Support Team _ Amy

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

[collinq]

HI @andyln33 ,

When you look at the reason for the error/schedue refresh being disabled what are the detail listed there?

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!