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 ,

For now, I didn't find that others encounter the issue.  And I didn't reproduce the issue either. I think you could create a support ticket to get a dedicated support. In this way, you could understand why happened and how to solve quickly and securely. 

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.