Business Central BLOB to text in Power BI

[Alex260570]

Hi all,

I need to convert a blob filed coming out of Business Central into a text field in Power BI.

It tried: 

Text.FromBinary(blobfield,0)) --> E}[I-.

Text.FromBinary([Activity Description],BinaryEncoding.Base64) --> E}[I-.

Binary.ToText([Activity Description],0) --> AkV9WwtJLS4BAA==

Binary.ToText([Activity Description],1) --> 02457d5b0b492d2e0100

Now I'm out of ideas. Can anybody give me a hint what I am doing wrong here? 

Thanks in advance

Alex

[v-stephen-msft]

Hi @Alex260570 ,

At the top of that column with the Binaries, there should be a double arrow you can click to Combine & Transform those files.  That will create new queries (and a function) you can use to transform an example file that will be applied to all the files.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Alex260570]

Thanks a lot for your answer. 

I tried that, but it only gives me an error message 

I know that all records only contain text because I created these fields by myself, and can encode and decode them without any issues in Business Central.