If you copy your connection details from the cloud console, you could paste them into the Excel Add-in. This isn't possible anymore - and I think never worked - in the new Add-in for Excel 365.
Please implement this for the new add-in, because otherwise this option in the Cloud Console would be superfluous in the future when the old add-in is deprecated.