Data Source Credentials
Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.
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.