I used to be able to connect to my corporate zOS IBM DB2 database from my personal home PC through Power BI Desktop using ODBC (and only with ODBC for unknown reasons). Today, all of a sudden, I'm getting the following error:
ERROR [HY010] [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
What's strange is that using Excel I can connect just fine to that database using the same ODBC driver.
So what's going on (all of a sudden) with Power BI Desktop and how do I overcome this frustrating obstacle?
Although I desperately want to know what causes this problem I will say that if you're fortunate enough to have an older version of Power BI laying around then uninstalling the February 2017 release and using the older release makes this problem go away. So it seems fairly clear to me that the issue resides with Microsoft. Hopefully Microsoft will respond and/or a future update will correct the source of the problem. Otherwise I'll be stuck using the November 2017 for the foreseeable future.
Did the same issue occur when you used IBM DB2 data source in Feb desktop? As you said the issue happened to your home PC, how about use ODBC data source in Feb desktop in company PC?
Hello @v-qiuyu-msft. I tried deleting and rebuilding the DSN but it still didn't work. Is it possible to get support on this issue please? We cannot upgrade to the March version of Power BI until we know that the ODBC will work. (Even better would be for the DB2 connector to work...but that's a different thread/issue). Thanks so much!
Sorry for the late response. I would suggest you create a support ticket at the end of this site, let the engineer look into the your real environment.
Does anyone know of any update on this? I'm able to connect to my ODBC source on a Windows 7 Machine via PowerBI desktop. However, when I try conencting on a Windows 10 machine, I get this same error. Though, I'm able to connect to the ODBC source through Excel on the Windows 10 machine.
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!