Forum Discussion
PowerPivot Excel Odata - No Saving of Password and User ID
Just in case anyone ever finds this question.
I had the same problem and found a thread from the year 2013 about the same problem. So the problem is still ongoing.
https://social.technet.microsoft.com/forums/office/en-US/480b2b7c-91c6-45f2-bd57-832bc6e030fc/powerpivot-data-connection-will-not-save-the-password
Fortunately lmil10's answer helped me to solve my problem:
"On the Excel ribbon, select the 'Data' tab. Select 'Connections' to open the 'Workbook Connections' dialog. Select the connection used in the PowerPivot model and select 'Properties'. Check the 'Save Password' check box. When you refresh the PivotTable you should get prompted to enter the password. Enter the password and save the workbook.
I did not check the 'Save Password' box within the PowerPivot environment. "