How do I change web credentials RRS feed

  • Question

  • Hi, I'm trying to access a REST based web service that returns XML, but I keep getting 400 errors back from the service, but the same Url works fine in a browser, so I want to try with some different headers, but the headers that you can use are restricted when using basic authentication, but I can't find where I can change the authentication. I've closed Excel and started a new workbook, but PowerQuery has remembered my credentials and I can't find where to change them.

    Does anyone know how I can stop PowerQuery from remembering the username/password for a given web site? - please mark correct answers

    Monday, March 3, 2014 8:09 PM


All replies

  • You can selectively delete credentials from the "Data Source Settings" option on the Power Query ribbon.

    Monday, March 3, 2014 9:45 PM
  • Thanks Curt, I had looked all over the place inside the Query designer, but had not noticed that option back in the ribbon in Excel - please mark correct answers

    Tuesday, March 4, 2014 1:14 AM