The external data source is connected to the workbook through a data connection, which is a set of information that describes how to locate, log in, query, and access the external data source.

A query data connection gets data from an external data source and stores that data in fields in the main or secondary data source of a form. You can then bind controls to those fields to …

A data connection is a connection between a Microsoft Office InfoPath form and an external data source, such as a database, Web service, XML file, or Microsoft Windows SharePoint …

A thorough overview of what you can do with external data: import and refresh, shape it with Power Query, secure it, define connections and properties.

A data connection file is an XML file with an .xml or .udcx file extension that contains connection information for a single external data source. This file is stored in a data connection library on …

Connections to external data may be disabled on your computer. To connect to data when you open a workbook, you must enable data connections by using the Trust Center bar, or by …

When you add a query data connection to a database, InfoPath creates a secondary data source with data fields and groups that corresponds to the way that the data is stored in the database.

The following table summarizes the kinds of data connections that you can use in Excel and which data connections are supported in Excel Services and in Excel Web App.

Using Microsoft Query, you can connect to external data sources, select data from those external sources, import that data into your worksheet, and refresh the data as needed to keep your …

Know which environment you're in Power Query is well-integrated into the Excel user interface, especially when you import data, work with connections, and edit Pivot Tables, Excel tables, …