Since October 24th 2022 the Microsoft version of the IBM DB2 connector returns an error on both Import and DirectQuery when working with JDEdwards on an IBM DB2 database (I haven't tried with other databases and tables).
"HISMPCB0002 In BasePrimitiveConverter the SetCodePage method has been called with a invalid codepage: 937"
This goes for the Power BI Desktop October 2022 version as well as the Power BI Service. When I roll back to the PBI Desktop September version I have no errors with my report. But when I publish the report to the service, the error reappears. Unfortunately this prevents us from doing any reports on the database. See also debate on
Solved: Re: Error Message Trying to Hit iSeries DB2 - Microsoft Power BI Community
which does not contain a solution even though it is marked as solved.
Hi @hannibalmads ,
power bi desktop has been updated for November version, have you tried using the latest version? Can you connect successfully?
Community Support Team Selina zhu