How to convert these encode url to normal text from API By M language

Hi, Tiger2514555 

According to your description, you have a problem with encoding and decoding URLs in Power Query, the encoded URLs are not correctly decoded back to normal text after translation, especially for Thai text.

To resolve this issue, you can use the encoding functions in Power Query and the function that decodes the encoded text of the URL. Here is a short action plan to solve your problem:

1. Encode the text of the URL: You have done this part correctly before sending the field to the Google Translate API.

2. Decode the translated text: after receiving the translated text from the API, you should decode it back to normal text. To do this, you can use the function in Power Query (Uri.UnescapeDataString).

Below is the existing code modified to include the decoding step.

#"Added translated column" = Table.AddColumn(#"Changed Type", "cause_of_defect(eng)", each if [causeOfDefact] <> "" then
    let
        encodedDescription = Text.Replace(Uri.EscapeDataString([causeOfDefact]), "%20", " "),
        apiEndpoint = "https://translate.googleapis.com/",
        relativepath = "translate_a/single",
        jsonResponse = try Json.Document(Text.FromBinary(Web.Contents(apiEndpoint, [RelativePath = relativepath, Query = [client = "gtx", sl = "th", tl = "en", dt = "t", q = encodedDescription]]))) otherwise null,
        translatedText = if jsonResponse <> null and List.NonNullCount(jsonResponse) > 0 and List.NonNullCount(List.First(jsonResponse)) > 0 then
            Uri.UnescapeDataString(Text.From(List.First(List.First(jsonResponse)){0})) else null
    else
        null
    in
        if translatedText <> null then translatedText else ""
)

In the modified code snippet above, the key addition is to use of to decode the translated. (text.Uri.UnescapeDataString)

Uri.UnescapeDataString (Note: While there's no direct documentation for , the concept is widely understood and the function name follows the convention used in many programming languages for decoding URL-encoded strings.)

Related link(Uri.EscapeDataString): Uri.EscapeDataString - PowerQuery M | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum