Power ON

            Save Datasource Password

            Option 1 (only works with PowerPivot datasources):

            Set the datasource password in Option\Datasource Passwords
            Make sure that the DS Name matches exactly the name of the PowerPivot datasource under Existing Connections in PowerPivot


            Option 2:

            Save the password in the workbook (it’s important to follow the steps bellow exactly):
            For Excel connections:
            o On the Excel ribbon, select the 'Data' tab
            o Select 'Connections' to open the 'Workbook Connections' dialog
            o Select the connection used and select 'Properties'
            o Enter the password
            o Check the 'Save Password' check box
            o Press Refresh All (if get prompted for the password, enter the password)
            o Save the workbook

            For PowerPivot connections:
            o Edit the PowerPivot connection
            o Enter the password
            o Check the 'Save Password' check box
            o On the Excel ribbon, select the 'Data' tab
            o Select 'Connections' to open the 'Workbook Connections' dialog
            o Select the connection used in the PowerPivot model and select 'Properties'
            o Check the 'Save Password' check box
            o Press Refresh All (if get prompted for the password, enter the password)
            o Save the workbook

            Option 3:

            Use PowerQuery to import the data
            Updated: 27 Jun 2017 01:24 PM
            Helpful?  
            Help us to make this article better
            0 0