Forum Discussion
Getting DB2 ID locked because of old password
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?
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/
