Forum Discussion

AltusTellus's avatar
AltusTellus
Helper III
4 years ago

Convert Binary data

Hi experts,   I have an issue with converting binary data to a readable PDF file. What I have done until now:   In a MS SQL table with financial transaction lines, I have a column with the binary...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi AltusTellus ,

 

Please check if the type of [document] column is Binary. 

 

 

Or you can try the following formula to see if it works.

 

Binary.ToText(Binary.From([Document]), BinaryEncoding.Base64)

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

  • AltusTellus's avatar
    AltusTellus
    Helper III
    4 years ago

    After the import into PBI Desktop, indeed, the [Document] column is of the type binary. I also used your formula, unfortunately with the same issue. Here you can find the orginal data and the data in PBI after the import. 

    Document example SQL to PBI 

     

    You will see that the total lenght of the original document is approximately 34.000 characters. In PBI column it is 1.024 characters after your formula. 

     

    Looking forward to your reply, many thnx!

    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      4 years ago

      Hi AltusTellus ,

       

      I can't reproduce your problem, could you allow editing the shared excel? That way I can test it based on your data. Currently I only can read the excel and cannot copy the data.

       

      Best Regards,
      Winniz

      • AltusTellus's avatar
        AltusTellus
        Helper III
        4 years ago

        I have checked, but when you wait about 30 seconds, the file can be downloaded.