This article describes the correct way to change/update your stored Konsolidator credentials in Excel for use with the Konnect API.
It is not recommended that you update your credentials by just clicking "Refresh" in your workbook, thereby getting prompted that your credentials are wrong, and then just updating them in the prompt. This might give you problems if you have multiple queries in your workbook as your changes might not apply to them all and you will continue to be prompted even when the credentials you have entered are correct.
In Excel, click on the "Data"-tab to show the "Data"-ribbon. On the "Data"-ribbon click on "Get Data", then click on "Data Source Settings...".
You will now be presented with a pop-up window in Excel. In this window select the Konnect API ("https://api.konsolidator.com/v2") and click "Edit Permissions...".
You should only select and change the above URL as the "https://api.konsolidator.com/v2/reports" inherits from the higher level URL. Unless you have previously changed both manually.
In the new pop-up window click the "Edit..."-button.
In the new pop-up window select "Basic" and type in the new "User name" and "Password". Then Click "Save".
Now click "OK" in the "Edit Permissions"-window and then click "Close" on the "Data source settings"-pop-up.
You are now ready to refresh your reports with your updated credentials.