Forum Discussion
comish4lif
Helper II
Helper II"Unable to Connect" to IBM DB2 Database via SQLStatement
I am trying to pull data from a DB2 data warehouse. I have set up the connection string and database name. I am using the following very simple query: select * from AEHRDW.FEMPRFDEM where FEMPR...
Thanks for all of the comments and suggestions. The SQL that I begin with was written and tested in IBM Data Studio.
But here's what solved it for me - I removed the semi-colon at the end of the SQL, and it works just fine now.
Hi comish4lif,
Based on research, this issue caused by syntax exception, you can try to copy current query to DB2 client and run it.
DB2 client will highlight the syntax that caused the error, you can modify on db2 client and copy the right query to power bi.
Regards,
Xiaoxin Sheng
comish4lifHelper II
Helper IIThanks for all of the comments and suggestions. The SQL that I begin with was written and tested in IBM Data Studio.
But here's what solved it for me - I removed the semi-colon at the end of the SQL, and it works just fine now.