Refresh dataset kept fail

I receive the same error.  In Desktop, can refresh report and it returns up to date information.  When published to Service refresh fails says that 1 or more datasource lacks permission error.  In Service, the DataSource credentials is GREYED out.  As an organisation, we are not allowed to have Personal Gateway, must use the business one.  The report is built on data via connecting to on site SQL Management Server, have also imported pre existing sql scripts, and some data comes from an Excel spreadsheets held either in our On Site Sharepoint folder, or in our network folders.   On Desktop, go to data source settings, cleared them, then re entered Credentials = Windows and Privacy Level = Organisational for all of them.  also checked that the Global settings matched.  Saved report and was able to Refresh without issue.  Re rublished to Served.  Tried Refresh, get the same error.  Please advise what else we need to check and do, also is their a troubleshooting document that covers this, thank you for your help