Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Help with Error: IBM DB2: ERROR [42704] [IBM][DB2] SQL0204N

I am able to connect to DB2 database from Power BI Desktop (SSL connection) and see the tables. But when I try to select a table I get the below error. Has anyone come across this error. Kindly help....
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi v-cgao-msft

     

    Thanks for your response. The issue is resolved now. I tried options suggested from various threads on connecting Power BI to DB2. The version of Power BI that I had was latest. Also, I couldn't get anywhere with the IBM documentation on the error. I even tried selecting Microsoft driver instead of IBM driver. But nothing worked for me.

     

    Finally the resolution was to select ODBC as the data source instead of IBM database and use SSL connection in order to connect to DB2. I was able to access the DB2 tables in mainframe successfully. 

     

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

1.  Ensure that you are using the latest version of Power BI Desktop, as updates often include fixes for connectivity issues.
Download Power BI Desktop from Official Microsoft Download Center

2. Refer to the official troubleshooting documentation:
** Troubleshooting ** "SQLCODE=-204, SQLSTATE=-42704" error when using DbConv to create new database
"DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704" when connecting to new Controller DB

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group