Unable to auto-refresh the dataset

While that is true Greg_Deckler - and I thought of that - on the report it self it says "This report is no longer refreshing due to stagnation, but you are here, so we are starting it back up again."

Not those exact words, but that is the essence. You don't need to do anything other than open it. MS kicks it all back in gear for you.

The only time I've ever seen it stop refreshing is if credentials on the data sources change/expire and need to be fixed, but that cannot be the case here as the manual refreshes are working, and they would also fail if it was a credential issue.

What can cause this too - if a refresh fails 4 times in a row, it will disable it to conserve on resources. I've seen this happen when a database goes down for a few hours and the refreshes all fail for lack of a datasource. When the DB comes back up, you have to go into Scheduled Refresh and turn it back on, but it remembers all of the times you had previously selected.