Forum Discussion

Ralfk's avatar
Ralfk
New Member
7 years ago

Problem with Codepage / Special character viuialisation

Hello everybody   maybe you can help me with my actual Power BI problem, which causes me a lot of troubles during my first walking attempts with PB:   My datasource is a DB2-database (encoding IS...
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
7 years ago

Tbh, that's not my strong suit and I also alway play around with different encodings.

Lately I had some cases where 65001 and 1250 worked (I'm sitting in Germany as well).

 

Otherwise you can try to apply the decoding with an optional parameter in your first import-step already: https://msdn.microsoft.com/en-gb/query-bi/m/db2-database 

Ralfk's avatar
Ralfk
New Member
7 years ago

Hi Imke,

 

thanks for your reply!

I must adsmit that I have no idea how to implement your advice.....

Is this a function I have to add in the query definition??
query definition

 

Regards Ralf

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    7 years ago

    You have to tweak the code where you import from the DB2-database.

    Currently it should look like so:

     

    DB2.Database(<YourServername>, <YourDatabasename>)

     

    try adding a "1" in a record at the end:

     

     

    DB2.Database(<YourServername>, <YourDatabasename>, [BinaryCodePage= 1])

     

     

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Ralfk,

     

    Have you solved your problem?

     

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    Best  Regards,

    Cherry