Data source settings

Microsoft Power Query for Excel saves a data source credential, or sign in identity, for each data source connection you have used and data source privacy levels. For more information about privacy levels, see Privacy levels.

I want to


Manage data source credentials

  1. In the Machine Settings group, click Data Source Settings.
  2. In the Data Source Settings dialog box, click Show All > Credentials.
  3. Select a data source credential item in the Manage settings for your data sources list.
  4. Click Edit Credential or Delete.

Top of Page Top of Page

Manage Privacy Levels

  1. In the Machine Settings group, click Data Source Settings.
  2. In the Data Source Settings dialog box, click Show All > Privacy levels.
  3. Select an Excel workbook item in the Manage settings for your data sources list.
  4. Mange the Privacy Level:
  1. Click Delete.
  2. Click the Privacy Level setting to the right of the selected an Excel workbook item, and select:
  • Public
  • Organizational
  • Private

Top of Page Top of Page

 
 
Applies to:
Excel 2013, Excel 2010