Data Source Credentials
This page of the Table Import Wizard enables you to enter the user name and password for the existing data source connection that you selected. To access the wizard from the PowerPivot window, on the Home tab, in the Get External Data group, click the type of data source from which you want to import tables.
User name
Enter the user name for the data source connection.Password
Enter the password for the data source connection.Save my password
Specify whether to store the password.