Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get Data - Different Query Results

Hello,   I am having an issue with inputting data from a DB2 database. This database contains non-alphanumeric characters (Chinese, Thai, etc). When I created and executed my query in DBVisualizer,...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Yes, the issue ended up being an improperly configured IBM Data Server Driver. The IBM driver that Microsoft points to in the link it provides was updated recently and it did not match our current configuration. The results of the query were then incorrect when trying to pull doublebyte data.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

An update:

 

I previously viewed older queries from DB2 into Power BI and this seems to be universal across all queries I made. Any columns are being converted to chinese characters. Is this a known issue?

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

Could you tell me if the data is loaded normally? If it is, kindly share the solutions. More people who encounter the same issue will benefit from here. 

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes, the issue ended up being an improperly configured IBM Data Server Driver. The IBM driver that Microsoft points to in the link it provides was updated recently and it did not match our current configuration. The results of the query were then incorrect when trying to pull doublebyte data.