Power query-web query

%3CLINGO-SUB%20id%3D%22lingo-sub-1540468%22%20slang%3D%22en-US%22%3EPower%20query-web%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540468%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20connect%20excel%20using%20get%20and%20transform-web%20query%3CBR%20%2F%3Ewhen%20excel%20asks%20credentials%2C%20I%20use%20my%20user%20name%20and%20password%2C%20but%20I%20have%20an%20error%20message%20%22%20we%20couldn%E2%80%99t%20authenticate%20with%20the%20credentials%20provided%22.%3CBR%20%2F%3Ewhen%20I%20directly%20integrate%20with%20excel%20(without%20power%20query)-using%20the%20%E2%80%9Cfrom%20web%E2%80%9D%20tool%2C%20excel%20accepts%20my%20username%20and%20password.%20but%20this%20doesn't%20allow%20me%20to%20use%20the%20query%20editor%2C%20which%20I%20need.%3CBR%20%2F%3EPlease%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1540468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I'm trying to connect excel using get and transform-web query
when excel asks credentials, I use my user name and password, but I have an error message " we couldn’t authenticate with the credentials provided".
when I directly integrate with excel (without power query)-using the “from web” tool, excel accepts my username and password. but this doesn't allow me to use the query editor, which I need.
Please help!

0 Replies