Administrators and data source owners can manage a published data source's connection information. The connection information describes the data source, its owner and how to access the data. You can embed database credentials in the connection to allow users to access the data directly or to enable scheduled refreshes for extracts. Alternatively, you can set the connection so that users are prompted to sign in. You can also change the server name for cloud-based data.
The data source owner or a site administrator can manage this information directly on the site. For example, you can update tags or change the data source owner, without having to republish the data source.
On the site that has the data source you want to modify, open the Explore page, then filter to show All Data Sources.
If there are a large number of data sources, use filters to narrow the list.
Tick the box next to the data source you want to update, and on the Actions menu, select Edit Connection.
Note: The Edit Connection option is not available for connections to extracts and file-based data.
Update the connection information and click Save.
For connections that support using saved credentials to refresh the data, see Refresh Data Using Saved Credentials.
Refresh the Data Connections page (press F5 or Ctrl+R) for your changes to take effect.