Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I used to be able to connect to IBM DB2 on z/OS database through Power BI Desktop using ODBC (and unfortunately only with ODBC for unknown reasons). Since the February (I believe) release of Power BI Desktop I now get the following error when trying to connect:
ERROR [HY010] [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
If I specify a SQL statement then I can connect to whatever table I specify in the SQL statement. But I prefer/need to have the full Navigator functionality that used to work.
What's strange is that using Excel I can connect just fine (with the full Navigator functionality) to that database using the same ODBC driver.
So what's going on with Power BI Desktop and how do I overcome this frustrating obstacle?
I've tried February 2017, March 2017, and April 2017 versions.
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.