Forum Discussion

dedelman_clng's avatar
dedelman_clng
Community Champion
2 years ago
Solved

Cannot convert type Binary to type Text - Text.ToBinary

 

I am getting the above error message on this piece of PowerQuery code

 

 

body = Text.ToBinary(Json.FromValue([login_id = client_id, security_key = client_secret]))

 

 

client_id and client_secret are defined as parameters, type "Text" and they are alphanumerics strings except for a single "@" in client_id and a single "-" in client_secret

 

The error doesn't even make any sense as I thought we're converting to binary not from binary.

 

I'm on Version: 2.126.927.0 64-bit (February 2024) if that makes any difference.

 

Any help appreciated,

David

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    That's because JSON.FromValue outputs a binary type, which you are then wrapping in Text.ToBinary. So you are now feeding the Text.ToBinary function an already binary value (the JSON.FromValue). PQ is saying " this value is not text".

     

    --Nate

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    That's because JSON.FromValue outputs a binary type, which you are then wrapping in Text.ToBinary. So you are now feeding the Text.ToBinary function an already binary value (the JSON.FromValue). PQ is saying " this value is not text".

     

    --Nate

    • dedelman_clng's avatar
      dedelman_clng
      Community Champion
      2 years ago

      Thanks Nate. I got that code from a MS support resource in another thread so I assumed it was correct code. Back to the drawing board...

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Can't you just remove the Binary.FromText function?