Forum Discussion
Charset issue with Basic authentication
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.
Because UTF-8 encoding for ASCII characters is identical to ASCII encoding, it should be safe to always encode with UTF-8. The only existing case this would "break" would be non-ASCII characters that today are being mapped to "?", but if anyone is depending on that behavior they can simply use "?" in their username/password instead.
The fix should be available in the December release of PBIDesktop.
When the fix will be available for Microsoft Excel ?
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.