Converting Binary datas

[Marcex1]

Hi,

I 'm going to convert binary datas from the querie shown below:

Can you please help me doing it?

Thank you in advance,

Marcello

[Anonymous]

Hi @Marcex1,

Which type of files you stored in these column with binary types?
If they are particular file type(e.g. excel, xml, csv...), you can try to add a custom column to use specific connectors to get these file contents.

For example: 

Use excel connector to get data from binary workbooks:

Excel.Workbook

Load images, and other Binary-typed data, into the Data Model

Regards,
Xiaoxin Sheng

[Marcex1]

Hello @Anonymous,

thank you for your reply . I would like to convert it directly inside powerBI and not using a connector , it is possible?

Regards,

Marcello

[Anonymous]

Hi @Marcex1,

Maybe you can try to convert them to text, it is hard to decode binary data without clearly file type and connector.

Text.FromBinary

Regards,

Xiaoxin Sheng