Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unable to translate Unicode character

Hello,

 

I've been running power bi and excel power query reports off of my company's 4d database for seven months or so. As of two weeks ago all queries are throw the following error: 

 

Unable to translate Unicode character \uDAD9 at index 5 to specified code page.

 

All the other applications that query our database are unaffected, it seems limited to power query. I used to be able to browse the top level tables of the database by selecting the source with no query, now even that is replace by the error.

 

Any help would be very appreciated!

Thank you

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Turns out it was the driver after all. A fresh installation of the driver fixed the problem.

     

    Thank you!

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

    Could you go to power query and find which step on step pane causes this error?

     

    Best Regards

    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Maggie,

       

      The error occurs immediately with the source step, where it did not before. I can guess its not the third party ODBC driver because it hasn't changed and other apps can successfully pull data using it. The error occurs with all queries, even simple ones that would pull only numeric data. 

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Turns out it was the driver after all. A fresh installation of the driver fixed the problem.

       

      Thank you!