Forum Discussion
Solved
Charset issue with Basic authentication
Hi, I'm using PowerQuery as a datasource for an Excel worksheet. Data are exposed by a REST API supporting Basic Authentication. It is working well except when user name or password contains spec...
At a high level, the answer is "whenever your Excel channel gets the December release of Power Query". There are more details in the below thread about how to determine which release channel you're on (which determines how quickly you'll receive PQ updates), and how to determine which version of PQ you have.
Hi bnobo ,
According to the syntax of Text.ToBinary():
The second parameter is optional encoding where you may try UTF-8
May help:
https://seddryck.wordpress.com/2017/06/22/encoding-basic-authentication-in-an-url/
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
