Several errors occurred during data refresh

Question

Hi guys,

I've placed a report on my Report Server. Users can view this report. But: my scheduled refresh doesn't work. It gives me the error "Several errors occurred during data refresh. Please try again later or contact your administrator."

I've contacted our administrator. He thinks it has something to do with the rights for the Service Account I used. You can see the connection was tested successfully. In my ETL I see that the refresh has started but it seems it can't finish the refresh. And that may be because of the rights for the Service Account.

Answer 1

"Connexion successful" mean "the network connection is operational but without any guaranty that the current user can "Read" the source data.

First, check your sa_capp account has "Read" right on the source database. For Microsoft SQL Server Analysis Services, add sa_capp account in a Role with "Read" authorization.

For Live query connexion, you don't need to schedule refresh.