Converting from Hex value to UTF8

[gargra]

Hi all,

I am currently using the Power BI Desktop version, and trying to convert a column that contains values in Hex format to a simple string (UTF8). Is there a common easily available function that I could use to make this work.

Thanks,

Rahul

[v-yulgu-msft]

Hi @gargra,

There is no direct function that can convert Hex value to decimal format. Please refer to below links to create custom function.

Power Query: Using Recursion to Solve Hex to Decimal Conversion

Power Query – Converting a hexadecimal number to decimal

Best regards,

Yuliana Gu

[gargra]

Thanks for your reply @v-yulgu-msft

Is there another custom function that i can use to convert the hex to a string format?

[v-yulgu-msft]

Hi @gargra,

What do you mean convert Hex to string? Can you show us some examples?

Regards,

Yuliana Gu