Forum Discussion

odzelashvili1's avatar
odzelashvili1
Icon for Helper I rankHelper I
5 years ago

Binary format in power query editor

Hello everyone,   I have some tables, where some columns has Binary format.   when i open my table in sql server management studio, I see this format: but, in power query editor, this colu...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, odzelashvili1 ;

You could use Binary.ToText([column],1) in power query ,and then Convert column with hexadecimal to decimal.

In addition, As stated in this article, this binary data type column is currently not supported in Power BI Desktop, and an idea about this issue has been submitted in this link, please vote it.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.