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...
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Ralfk,

 

Based on your information, I'm a little confused about your requirement. 

 

Do you want to convert the special character in german to standard character?

 

I'm not good at Power Query, ImkeF may help you.

 

In addition, you could share some data sample and your desired output so that we could understand your requirement better and get the solution.

 

Best Regards,

Cherry

  • 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])

         

         

  • Ralfk's avatar
    Ralfk
    New Member
    7 years ago

    Hi Cherry,

    i'm sorry to confuse you!
    Well let's try to give some more details:

    These German special characters are already stored correctly in the DB2 -database.

    Example:
    The town, 'Cologne' is called in German 'Köln'. This is what I wanted to see in my example instead  of these strange symbols....

     

    In general I can retrieve these data out of the DB and visualize it without any problems.
    And as I'm working in the same PC with Power BI and other BI-tools, I can not understand what goes wrong .....

    I hope to explain my problem a little bit clearer now....

     

    Regards Ralf