Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi - I am using the following formula to create some JSON:
Text.FromBinary(Json.FromValue(
[domain=[company.domain],
companyName=[company.company],
speakerName=[speaker.title],
speakerTitle=[speaker.roles.job_title],
speakerCompany=[speaker.roles.company_name],
speakerImageURL=[speaker.thumbnail],
speakerURL=[speaker.permalink],
sessions={[sessions]}]))
But special characters get encoded e.g. Damsgård is contained in the column data but gets encoded to Damsg\u00e5rd in the JSON. I've tried using UTF8 encoding value etc.
How can I stop this or change these back to the actual characters? Note I don't know how many cases of this there are in the data so an individual find & replace is not ideal.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.