It's becoming pretty clear to me that scheduled refresh is not going to be a good option for us. We have a beast of a SQL server but scheduling 36 data refreshes is putting it on its knees. Too many bugs in the Data Gateway.
My question is simply this - shouldn't I be able to disable the scheduled refresh (already done) and allow the user of the report / dataset to trigger a refresh manually, when they are viewing their report? If so, how is that done?
I would suggest when you set up the Data Source in the Data Gateway, you would need to add them into the Users List for each Data Source that is linked to your datasets.Please have a look at below article.