Forum Discussion

DMC_PBI's avatar
DMC_PBI
Frequent Visitor
4 years ago

ODBC connection error IM002 on report server

Hi, We are running Power BI Report server Version 1.11.7815.26414 (May 2021) on a server with a 64-bit operating system.   I'm tyring to create an ODBC data source on the Report Server to run a pa...
Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi DMC_PBI ,

 

Try the following connection methods to see if they work:

More details, you can read below document:

MySQL :: MySQL Connector/NET Developer Guide :: 4.1 Creating a Connector/NET Connection String


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • DMC_PBI's avatar
    DMC_PBI
    Frequent Visitor
    4 years ago

    Hi Henry,

     

    I tried the connection methods you suggested and still cannot get the connection working on the Power BI Report server. 

     

    The ODBC drivers are installed, a system DSN is created for both the 64-bit and 32-bit drivers and both DSNs test successful.

     

    I create a Data Source on the Power BI Report Server using type ODBC (Preview) with the connection string and I recevie the following error. I have tried multiple connection strings and receive the same error.