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

     

dpFr33's avatar
dpFr33
Advocate II
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.