Forum Discussion
PowerPivot Excel Odata - No Saving of Password and User ID
Hey guys,
I want to work with PowerPivot in excel and I got an URL with Odata from my company.
So I came to this Point here when I click on advanced : (Screenshot is in german)
Here I should change integrated security on "BASIC" and then just enter password and username.
When I do this and clicking ok, it is not saving these details of user id and password and then because of this I got no connection and can not go on further.
I did this several times but It never saves the entered information.
I also entered the right url and in this little window the test connection is successfull. but again, when i click on ok and try to test it, it says i have to enter user id and password.
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.
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. "
