Converting from Hex value to UTF8

Question

Hi all,&nbsp;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.&nbsp;Thanks,Rahul

v-yulgu-msft · Answer

Hi&nbsp;gargra,
&nbsp;
There is no direct function that can convert Hex value to decimal&nbsp;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
&nbsp;
Best regards,
Yuliana Gu

gargra · Answer

Thanks for your reply&nbsp;v-yulgu-msft&nbsp;Is there another custom function that i can use to convert the hex to a string format?

v-yulgu-msft · Answer

Hi&nbsp;gargra,
&nbsp;
What do you mean convert Hex to string? Can you show us some examples?
&nbsp;
Regards,
Yuliana Gu

Forum Discussion

Converting from Hex value to UTF8

3 Replies

Related content

Snowflake connector: "We cannot convert the value null to type Text"

[Expression.Error] cannot convert null value to Logical

Converting [List] to text value

Converting to Percentage

Cannot convert value to type table