When refreshing your existing reports based on Konnect and also when getting connected for the first time, cf. the guide Connecting to Konnect INDSÆT LINK, you might be met by this prompt:
Should this happen it is most likely due to the password being wrong (if the username is correct of course) and often connected to the fact that your password has expired and you need to log in to Konsolidator in the web application and choose a new one. Passwords in Konsolidator expires every 3 months, but Excel has no way of showing and handling this, so it should initially be handled on the web and then subsequently changed in Excel.
Please be aware that if you are already logged into Konsolidator when opening the web application you may have to manually log out and then log back in again to be prompted for the potentially needed password change
Even when you have successfully changed your password in Konsolidator and while getting yourself out of the above prompt (might require multiple clicks when attempting to refresh a workbook with multiple queries against the API) you might be met with one or both of the following errors:
This can happen even if the correct credentials has subsequently been entered in the initial prompt because Microsoft will use the original credentials from the time "Refresh" was initiated to complete the update of the remaining queries.
To successfully update your stored password please refer to this guide:
Updating your Konnect credentials in Excel