Forum Discussion
Error Message Trying to Hit iSeries DB2
ChuckS After much investigation, I believe there is an issue with the latest version of PBI. I went to the archive Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn and pulled the September version https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2022-09_x64.exe I was able to connect to the DB2 without issue.
Hi , MA_guy_VER
1. You may try to update the power bi desktop to latest version and try it again,
https://www.microsoft.com/en-us/download/details.aspx?id=58494
2. Please try starting Power BI as Administrator.
For more information, you can refer to :
Power Query IBM Db2 database connector - Power Query | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Just to highlight - it is an issue with the latest version of Power BI Desktop (as of October 24th) - for now you need to roll back to September 2022 to avoid the issue.
I can confirm it is a bug in the Oct 2022 version. I had previosly uninstalled/reinstalled the latest version and ran as administrator, neither worked.
Rolled back to Sept 2022 version and everything worked as normal.
This is still an issue in Nov 2022 version. Very disappointing that its not fixed yet.
Run as Administrator worked for me. (Did not work, had to install the Sept 2022 version.)
Running as Admin made no difference in my case. Rolling back to Sept 2022 version was the only thing that got me up and running again.
Even is running as Admin worked, this is not a solution. While I am a domain adminstrator so my loging can do pretty much anything, I have many users that do not so this kind of work around would not help then even if it has worked.
Hi, thank you for your solution. The DB2 connection issue is prevented within the Sep 2022 version of PowerBI Desktop. But when I published it, try to set auto refresh schedul, it raises the same error code "HISMPCB0002 In BasePrimitiveConverter the SetCodePage method has been called with a invalid codepage: 937". Would you have any advice on this?
