Hello Office 365 experts,

I have a Power Query in Excel that connects to a data source. 

I need to have the credentials to that source changed, however Excel seems to remember the older username/password, and does not prompt me any more for them, nor allows me to change them.

Does anyone know where I can change them, or how to clear Excel's memory?
Thanks

• Moved by Fei XueMicrosoft contingent staff Monday, June 15, 2015 1:56 AM

Hi 3ebs,

Thanks for posting in MSDN forum.

This forum is for devleopers discussing developing issues about Excel applcation. Since the issue is more relative to end-user, I would like to move it to Excel IT pro discussions forum.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thanks for your understanding.

Regards & Fei

Hi,

Please follow these steps to modify/clean the credentials:

• In the Power Query ribbon, in Settings, select Data Source Settings.

• In the Data Source Settings dialog box, select a data source and select Edit.

• In the new Data Source Settings dialog that appears, under Credentials, select Edit.

• Select the credential type from the options on the left, and if necessary, provide the Username and Password (or other appropriate information) for the data connection.

Reference:

https://support.office.com/en-za/article/Data-source-settings-Power-Query-9f24a631-f7eb-4729-88dd-6a4921380ca9?ui=en-US&rs=en-ZA&ad=ZA

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 2 hours 17 minutes ago
• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 2 hours 17 minutes ago

Hi,

Please follow these steps to modify/clean the credentials:

• In the Power Query ribbon, in Settings, select Data Source Settings.

• In the Data Source Settings dialog box, select a data source and select Edit.

• In the new Data Source Settings dialog that appears, under Credentials, select Edit.

• Select the credential type from the options on the left, and if necessary, provide the Username and Password (or other appropriate information) for the data connection.

Reference:

https://support.office.com/en-za/article/Data-source-settings-Power-Query-9f24a631-f7eb-4729-88dd-6a4921380ca9?ui=en-US&rs=en-ZA&ad=ZA

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"