cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MA_guy_VER
Advocate I
Advocate I

Error Message Trying to Hit iSeries DB2

Has anyone encountered the following error?  PBI was working then on reboot of machine, this message appeared.  Both import and directquery cannot access the live server. Server is up and running and I can access it from all other applications without issue. 

 

DataSource.Error: An error happened while reading data from the provider: 'HISMPCB0002 In BasePrimitiveConverter the SetCodePage method has been called with a invalid codepage: 937.'
Details:
DataSourceKind=DB2
DataSourcePath=x.x.x.x:446;Database

1 ACCEPTED SOLUTION

@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-2... I was able to connect to the DB2 without issue. 

View solution in original post

49 REPLIES 49

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.

It will be fixed in Jan 2023

Is there an update on this? This is still an ongoing issue on the most recent version of Power BI as of February.

Doesnt seem like Jan update has been released yet. Latest available PBI version is still Dec release. Hope they release the Jan update soon because this is causing a serious backlog of work for my team. 

I went back to the September 2022 version and I'm not updating either the web version or the desktop version again until one of us who actually uses it says a new version works.  So, who will be the first person to test drive when a new release comes out?  Not me!

Unfortunately our IT policy auto updates PBI to latest version automatically and they do not alllow reg edits to implement the work around. We're stuck waiting for the update ☹️

@ahp-sig bribe the IT admin to place you into another container with a modified group policy 😉

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors