Forum Discussion

M_nwadibia's avatar
M_nwadibia
Resolver III
3 years ago
Solved

Data Refresh error in Report Server

Hello, I have the error below when I try to set up data refresh for Power BI report in report Server. I have used ODBC connection for the report and I have tried OLEDB connection for the  same repo...
11
  • d_gosbell's avatar
    d_gosbell
    3 years ago

    It sounds like you do not have the Oracle drivers installed on the Report Server machine. You will need to talk to the an admin of that server to get them to install those. Note that you probably cannot use a DSN to connect since the DSN definition is only on your machine and does not exist on the server, so when it goes to do a scheduled refresh it cannot find the server details.

  • M_nwadibia's avatar
    M_nwadibia
    3 years ago

    Thank you for your response.

d_gosbell's avatar
d_gosbell
Super User
3 years ago

It sounds like you do not have the Oracle drivers installed on the Report Server machine. You will need to talk to the an admin of that server to get them to install those. Note that you probably cannot use a DSN to connect since the DSN definition is only on your machine and does not exist on the server, so when it goes to do a scheduled refresh it cannot find the server details.

  • M_nwadibia's avatar
    M_nwadibia
    Resolver III
    3 years ago

    Thank you for your response.