Forum Discussion

n4styrat's avatar
n4styrat
Copper Contributor
Nov 20, 2021

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.

MS Build

1 Reply

  • Hopethishelps's avatar
    Hopethishelps
    Copper Contributor
    Jan 21, 2024

    n4styrat 

    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.  "

     

     

     

     

Resources