topic Re: Data Refresh Error in Report Server in Report Server

Data Refresh Error in Report Server

M_nwadibia — Thu, 06 Oct 2022 14:27:58 GMT

I am relatively new to report server environment and I have two questions.

1. How do I fix this error below in trying to set up data refresh in report server for Power BI reports. The ODBC connections work well on

the Desktop, Manual Refresh works well on the Desktop.

2. Which Credentials should I use for Windows authentication for data refresh? Is it the Power bi Admin credentials or my windows log in credentials to my computer?

Re: Data Refresh Error in Report Server

Shahfaisal — Thu, 06 Oct 2022 18:02:36 GMT

Two quick suggestions:

1. Make sure you have setup the driver under the "System DSN" and not "User DSN"

2. Are you using a 32-bit driver or 64-bit? I would switching from one to the other to see if that is the issue.

Re: Data Refresh Error in Report Server

M_nwadibia — Fri, 07 Oct 2022 16:03:42 GMT

1. I have the driver set up under User DSN but will change it

2. I am using a 64bit driver.