Forum Discussion
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?
1. I have the driver set up under User DSN but will change it
2. I am using a 64bit driver.
2 Replies
- ShahfaisalSolution Sage
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_nwadibiaResolver III
1. I have the driver set up under User DSN but will change it
2. I am using a 64bit driver.