Data source settings (Power Query)
Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.
Power Query 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
-
In the Power Query ribbon, in Settings, select Data Source Settings.
-
In the Data Source Settings dialog box, select a data source and select Edit.
-
In the new Data Source Settings dialog that appears, under Credentials, select Edit.
-
Select the credential type from the options on the left, and if necessary, provide the Username and Password (or other appropriate information) for the data connection.
Manage Privacy Levels
-
In the Power Query ribbon, in Settings, select Data Source Settings.
-
In the Data Source Settings dialog box, select a data source and select Edit.
-
In the new Data Source Settings dialog that appears, under Privacy Level, select the down-arrow and select the appropriate privacy level for the data source:
-
None
-
Public
-
Organizational
-
Private
-
No comments:
Post a Comment