Connect to data using generic interfaces
You can connect to a multitude of different data sources using built-in connectors that range from Access databases to Zendesk resources. You can also connect to all sorts of other data sources to further expand your connectivity options, by using the generic interfaces (such as ODBC or REST APIs) built into Power Query Desktop and Power Query Online.
Power Query data interfaces
Power Query includes an ever-growing collection of connectors that are built to connect to a specific data source. For example, the SharePoint list connector provides specific fields and supporting information during the connection sequence that are designed for SharePoint lists. Other data sources found in the window that appears when you choose to get data (in Power Query Desktop) or choose a data source (in Power Query Online) work in the same way.
In addition, you can also connect to data sources that aren't identified in the get data and choose data source lists by using one of the following generic data interfaces:
- ODBC
- OLE DB
- OData
- REST APIs
- R Scripts
By providing the appropriate parameters in the connection windows that these generic interfaces provide, the world of data sources you can access and use in Power Query grows significantly.
In the following sections, you can find lists of data sources that can be accessed by these generic interfaces.
Data sources accessible through ODBC
The ODBC connector in Power Query lets you import data from any third-party ODBC driver simply by specifying a Data Source Name (DSN) or a connection string. As an option, you can also specify a SQL statement to execute against the ODBC driver.
Data sources accessible through OLE DB
The OLE DB connector in Power Query lets you import data from any third-party OLE DB driver simply by specifying a connection string. As an option, you can also specify a SQL statement to execute against the OLE DB driver.
The following list details a few examples of the data sources that Power Query can connect to using the generic OLE DB interface.
| Power Query generic connector | External data source | Link for more information |
|---|---|---|
| OLE DB | SAS OLE DB | SAS provider for OLE DB |
| OLE DB | Sybase OLE DB | Sybase provider for OLE DB |
Data sources accessible through OData
The OData feed connector in Power Query lets you import data from any OData URL simply by typing in or pasting the OData URL. You can add multiple URL parts by typing or pasting those links in the text boxes provided in the OData feed window.
The following list details a few examples of the data sources that Power Query can connect to using the generic OData interface.
| Power Query generic connector | External data source | Link for more information |
|---|---|---|
| OData | Coming soon | Check back soon for OData data sources |
Data sources accessible through REST APIs
You can connect to data sources using the REST APIs and thereby use data from all sorts of data sources that support REST.
The following list details a few examples of the data sources that Power BI Desktop can connect to using the generic REST APIs interface.
| Power BI Desktop generic connector | External data source | Link for more information |
|---|---|---|
| REST APIs | Couchbase DB | Couchbase REST API information |
Data sources accessible through R Script
You can use R scripts to access data sources, and use that data in Power BI Desktop.
The following list details a few examples of the data sources that Power BI Desktop can connect to using the generic R scripts interface.
| Power BI Desktop generic connector | External data source | Link for more information |
|---|---|---|
| R Script | SAS Files | R script guidance from CRAN |
| R Script | SPSS Files | R script guidance from CRAN |
| R Script | R Statistical Files | R script guidance from CRAN |