Forum Discussion

hokiefan1113's avatar
hokiefan1113
Icon for Advocate I rankAdvocate I
8 years ago

ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default drive

Hi, I'm trying to enter credentials for data sources on a pbi file on power bi report server, but when I enter the credentials for a specific data source, this error pops up. How do I fix this?

 

1 Reply

  • Might not be the same issue, but I've had error messages after entering credentials in RS, while at the same time, no errors in Desktop.

    Found that the problem in my case was that I'd connected using AD for convenience in desktop, and then tried to enter Basic Authentication credentials in Report Server. Fixed by amending my desktop version to connect using a login and then re-deployed - didn't get any errors after that.