Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Hi @kat_ma_88
As tesed, it seems Power query can't recognize the "°C" in that format.
You could try this workaround.
Hi @kat_ma_88
As tesed, it seems Power query can't recognize the "°C" in that format.
You could try this workaround.