If you are using azure deployment profiles for Visual Studio you can find the deployment password here:
Login to portal, select the web app service, click the link “Get publish profile” to download. Open the xml file and find the password in element publishProfile attribute userPWD.
Source: Where do I get my actual Azure Website Deployment password? – Stack Overflow