Forum Discussion
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...
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
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
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...