Getting DB2 ID locked because of old password

[John Murray]

I'm using G&T to connect to a DB2 database.  I have 4 queries in the workbook that connect to the same database.  If I run all 4 queries and my password has expired, my ID gets locked because of too many tries with old password (our host system locks on 3rd attempt). 

How do I have the password not stored so that on attempting to connect to the DB on 1st query I get prompted for the password - and then that password is used in next 3 queries also?

[#2]

Hi John,

If you connect to the same database you may use only one source query and the rest as a references on it. The idea is here https://powerpivotpro.com/2017/05/power-query-magic-part-1-always-good-references/