Hash SHA256 in Dataflows Gen2

[CountMcCracker]

Is it possible to create a hash key using the SHA256 algorithm in dataflows gen2? The function I am invoking is returning an error. Is there an issue with the function or is SHA256 not supported?

Here is the function: 

let

    Hash = (input as text) as text =>

        let

            // Convert text to binary

            inputBinary = Text.ToBinary(input, TextEncoding.Utf8),

            // Compute SHA-256 hash

            sha256Binary = Binary.Hash(inputBinary, HashAlgorithm.SHA256),

            // Convert hash to hex string (64 characters)

            Hex = Binary.ToText(sha256Binary, BinaryEncoding.Hex)

        in

            Hex

in

    Hash

[vojtechsima · Accepted solution]

Hey, @CountMcCracker ,

you have issues because Binary.Hash doesn'T exist.

Check this post to implement it:
https://community.fabric.microsoft.com/t5/Power-Query/SHA256-in-Power-Query-and-DAX-Performance-Anal...

[CountMcCracker]

Thank you much! I really appreciate it!

[v-menakakota]

Hi @CountMcCracker ,
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @vojtechsima   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

Best Regards, 
Community Support Team  

[v-menakakota]

Hi @CountMcCracker ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

Best Regards, 
Community Support Team