I'm using multiple sources and I need to refresh one data source on a daily basis and one on a 15-minute interval. I think this could be made possible via publishing data sources online and building workbook off those published data sources on the server, but not sure of the specifics. Does anyone have experience with this and can offer some explanation? I searched online but haven't seen too many readings on this.
It's pretty straight-forward.
Just publish your datasource to the Server like this:
Then, on the publishing dialog pick a schedule (might need to create it in advance) and, if you have 9.3, check the checkbox (in order to automatically update workbook to use published datasource):
Next, repeat all above for remaining datasources and you are all set!