Json.FromValue encoding issues with posting a record

[kat_ma_88]

Hello Community,

i hope someone can help with an encoding issue. I have to post a record which contains special characters "°". If i'll post the Json.FromValue record to an enpoint i'll get the utf8 equivalent and not the special character ({"unit":"\u00b0 C"}). Same with the following statement:

Text.FromBinary(Json.FromValue([unit="° C"])) -> {"unit":"\u00b0 C"} BUT it should be {"unit":"° C"}

Any ideas? Both functions Text.FromBinary and Json.FromValue have utf8 as default.

[v-juanli-msft · Accepted solution]

Hi @kat_ma_88 

As tesed, it seems Power query can't recognize the "°C" in that format.

You could try this workaround.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.