Forum Discussion

RemiAnthonise's avatar
RemiAnthonise
Helper V
6 years ago
Solved

Several errors occured during data refresh.

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 occured during data refresh. Please tr...
Need Help
Show and Tell
Tips and Tricks
  • dpFr33's avatar
    dpFr33
    6 years ago

    Hi,

     

    "Connexion successfull" mean "the network connection is operationnal but without any garanty that the current user can "Read" the source data.

     

    First check your sa_capp account has "Read" right on 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.

     

    Regards,

    Denis

     

RemiAnthonise's avatar
RemiAnthonise
Helper V
6 years ago

Thanks dpFr33  Denis,

 

I did some editing in the rights and I successfully refreshed my report.

Thanks!

pouyanebrahimi's avatar
pouyanebrahimi
Helper I
6 years ago

Hello RemiAnthonise , 

I am experiencing the same problem. Would you please let me know how you overcome this challenge?

Thanks in advance.