Unable to translate Unicode character

[Anonymous]

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

[v-juanli-msft]

Hi @Anonymous 

If you use Power query to connect to your database again, does error occurs?

is there any strange character in your database? or meet some limitation of Power query?

https://support.microsoft.com/en-us/office/power-query-specifications-and-limits-5fb2807c-1b16-4257-aa5b-6793f051a9f4

Please make sure to use the lastest power bi desktop.

Best Regards

Maggie

[Anonymous · Accepted solution]

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

Thank you!

[v-juanli-msft]

Hi @Anonymous 

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

Best Regards

Maggie

[Anonymous]

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.