topic Data Refresh error in Report Server in Report Server

Data Refresh error in Report Server

M_nwadibia — Tue, 04 Oct 2022 14:55:19 GMT

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 report too but I get the same error in each case.

What steps should I take to resolve this problem?

Re: Data Refresh error in Report Server

M_nwadibia — Tue, 04 Oct 2022 16:37:18 GMT

Below is the error detail. I get The same error when I try basic authentication or Windows authentication. The database is Oracle while SQL server clients is installed in another server

Re: Data Refresh error in Report Server

d_gosbell — Tue, 04 Oct 2022 23:16:03 GMT

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.

Re: Data Refresh error in Report Server

M_nwadibia — Wed, 05 Oct 2022 02:32:54 GMT

Thank you for your response.