is it possible to get a mail notification for all the user involved by the report when the refresh is KO ?
the "Notify" Option on the "Distribute" works only if the refresh is OK.
It is possible but it would not be a good ideal. The only way you can do this would cause any failure to send an email out to the users. There is no way to do it for certain users and certain documents.
Retrieving data ...