Data Refresh Error in Report Server

[M_nwadibia]

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?

[Shahfaisal]

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.

[M_nwadibia · Accepted solution]

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

2. I am using a 64bit driver.