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...
It does work on desktop.
All I have to do is download the latest version of dataset --> hit refresh locally on my PC --> upload the dataset again. That whole thing sometime takes me 20-30mins of manual working.
And because of the update on sharepoint worksheet is serveral time on some day so It's really painful doing those manual stuff.
christinepayton
Most Valuable Professional
Most Valuable ProfessionalYeah I would re-enter the credentials in the datasource settings in the cloud, potentially check your datasource privacy settings and make sure they are all set (usually "organizational") and republish. Those things will usually give you an error message, though, so not sure why it would just not be present...