Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
robsurr
Frequent Visitor

Has this been fixed in a newer version?  And which version?

February 2023 version (remember to update the data gateway as well)

hannibalmads
Advocate III
Advocate III

Power BI February 2023 released yesterday has fixed this issue. Hooray!

Where did you find the download? All the links I've used still have the old (Dec) version...

Unfortunately I found that to be true too, the only downloads on the Microsoft website are the new versions.

Fortunately, when I looked in the downloads folder of my computer the version I downloaded in September was still there.

Thanks. I am actually waiting for the updated "on premise data gateway", sorry. That one doesn't appear to be released yet unless burried somewhere as all the general links I've tried still link to the December version...

Looks like the new on-premise gateway was released. 

 

https://go.microsoft.com/fwlink/?LinkId=2116849&clcid=0x409

Ahh,  of course. Well, the December version of the gateway was released Jan 17 so you might have to wait a while.

https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-december-release/

At least we are half updated 🙂

MA_guy_VER
Advocate I
Advocate I

The currently targeted date for the SU2 release - for both Power BI Desktop, and for the On-Premises Data Gateway - is February 13 2023 according to Microsoft.  We shall see.  I will give it a spin and report back findings once it is released.

CathyT
Frequent Visitor

I have this problem also (using 32bit version).  Rolling back to September is not a solution for me because I don't have the September version!

Hi @CathyT  - You can click the link on the page for the September version 32bit:  Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

OMG, this is true!  If you scroll down under the AUGUST 2022 UPDATE header to right above the JULY 2022 UPDATE header there is a link called AUGUST 2022 VERSION 32 BIT (also 64 bit) and it actually does download what looks to be the older version!

I went to that page already.  The link there for the Download Center takes you to the same place where the most recent version is.  The digital signature date on the file is 11/11/2022.  Which is the October update.

If you had issues prior, the September file seems to be able to download now... FYI...

 

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-monthly-updates

waynesteele
Microsoft Employee
Microsoft Employee

I am a developer who works on the Mashup (aka PowerQuery) engine.

 

If you contact support for this issue, please tell them it has been opened in ICM#348059006, and in Power Query Bug #945088.

I have attached workaround instructions in both of those places.

 

I have also placed the workaround steps here:  https://1drv.ms/u/s!AoVHHqNdBM4VgQfWbxvB-rZOCWfr?e=amInQA 

 

 

Has this been fixed yet in the December Update?

There is no December update. The latest version is of November and the issue remains.

Please go to the issue report here Issue with IBM DB2 connector October 2022 release ... - Microsoft Power BI Community

and click on upvote to help us make this vital for Microsoft to include in the next update, thanks.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.