Forum Discussion

M_nwadibia's avatar
M_nwadibia
Resolver III
3 years ago
Solved

Data Refresh Error in Report Server

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?

 

 

 

  • M_nwadibia's avatar
    M_nwadibia
    3 years ago

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

    2. I am using a 64bit driver.

2 Replies

  • 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's avatar
      M_nwadibia
      Resolver III

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

      2. I am using a 64bit driver.