Forum Discussion
refresh data from excel sharepoint with on-primes data gateway
hi all, I have a dataset that connect to different kinds of data source: SQL server, sharepoint worksheets. I set up a auto refresh schedule that trigger once a week, each time I complete updat...
christinepayton
Most Valuable Professional
Most Valuable ProfessionalIf you refresh it in the desktop, does it update?
If it works in the desktop, but not cloud, it indicates that there's something up with the datasource credentials that are stored for SharePoint or with data privacy settings. If it doesn't work in either one, then there's an issue with the query (e.g. people renaming sheets that break the query reference, though this will usually give an error).