使用 Power BI Desktop 中的泛型接口连接到数据Connect to data using generic interfaces in Power BI Desktop

使用从访问数据库Zendesk 资源的内置数据连接器,可以连接到 Power BI Desktop 中多种不同的数据源,如“获取数据”窗口中所示。You can connect to a multitude of different data sources in Power BI Desktop, using built-in data connectors that range from Access databases to Zendesk resources, as shown in the Get Data window. 通过使用内置于 Power BI Desktop 中的泛型接口(如 ODBCREST API),也可以连接到所有其他类型的数据源,这甚至会进一步扩大你的连接选项。You can also connect to all sorts of other data sources, which even further expands your connectivity options, by using the generic interfaces (such as ODBC or REST APIs) built into Power BI Desktop.

Power BI Desktop 数据接口Power BI Desktop data interfaces

Power BI Desktop 包括一个不断增长的数据连接器的集合,用于连接到特定数据源。Power BI Desktop includes an ever-growing collection of data connectors that are built to connect to a specific data source. 例如,SharePoint 列表数据连接器在为 SharePoint 列表设计的连接顺序期间提供特定字段和支持信息,这与选择“获取数据 > 更多...”时出现的窗口中的其他数据源的情况相同(如上一张图片中所示)。For example, the SharePoint List data connector provides specific fields and supporting information during the connection sequence that are designed for SharePoint Lists, which is the case with other data sources found in the window that appears when you select Get Data > More... (shown in the previous image).

此外,通过使用以下任一泛型数据接口,Power BI Desktop 可连接到未在获取数据列表中专门标识的数据源:In addition, Power BI Desktop lets you connect to data sources that aren't specifically identified in the Get Data lists, by using one of the following generic data interfaces:

  • ODBCODBC
  • OLE DBOLE DB
  • ODataOData
  • REST APIREST APIs
  • R 脚本R Scripts

通过提供这些泛型接口所提供的连接窗口中的适当参数,在 Power BI Desktop 中可以访问和使用的数据源显著增加。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 BI Desktop grows significantly.

在以下部分中,可以找到通过这些泛型接口进行访问的数据源的列表。In the following sections, you can find lists of data sources that can be accessed by these generic interfaces.

使用 Power BI Desktop 无法找到想要使用的数据源?Can't find the data source you wanted to use with Power BI Desktop? 告诉我们,以便我们将它添加到我们的想法和请求的列表。Please let us know so we can add it to our list of ideas and requests.

数据源可以通过 ODBC 访问Data sources accessible through ODBC

Power BI Desktop 中的 ODBC 连接器使你仅通过指定数据源名称(DSN)连接字符串即可从任何第三方 ODBC 驱动程序导入数据。The ODBC connector in Power BI Desktop lets you import data from any third-party ODBC driver simply by specifying a Data Source Name (DSN) or a connection string. 作为一个选项,还可以指定 SQL 语句,以执行 ODBC 驱动程序。As an option, you can also specify a SQL statement to execute against the ODBC driver.

以下列表详细介绍了通过使用泛型 ODBC 接口,Power BI Desktop 可以连接到数据源的几个示例。The following list details a few examples of data sources to which Power BI Desktop can connect by using the generic ODBC interface.

Power BI Desktop 泛型连接器Power BI Desktop generic connector 外部数据源External data source 有关详细信息的链接Link for more information
ODBCODBC CassandraCassandra Cassandra ODBC 驱动程序Cassandra ODBC driver
ODBCODBC Couchbase DBCouchbase DB Couchbase 和 Power BICouchbase and Power BI
ODBCODBC DynamoDBDynamoDB DynamoDB ODBC 驱动程序DynamoDB ODBC driver
ODBCODBC Google BigQueryGoogle BigQuery BigQuery ODBC 驱动程序BigQuery ODBC driver
ODBCODBC HbaseHbase Hbase ODBC 驱动程序Hbase ODBC driver
ODBCODBC HiveHive Hive ODBC 驱动程序Hive ODBC driver
ODBCODBC IBM NetezzaIBM Netezza IBM Netezza 信息IBM Netezza information
ODBCODBC PrestoPresto Presto ODBC 驱动程序Presto ODBC driver
ODBCODBC Project OnlineProject Online Project Online 文章Project Online article
ODBCODBC Progress OpenEdgeProgress OpenEdge Progress OpenEdge ODBC 驱动程序博文Progress OpenEdge ODBC driver blog post

数据源可以通过 OLE DB 访问Data sources accessible through OLE DB

Power BI Desktop 中的 OLE DB 连接器使你仅通过指定连接字符串即可从任何第三方 OLE DB 驱动程序导入数据。The OLE DB connector in Power BI Desktop lets you import data from any third-party OLE DB driver simply by specifying a connection string. 作为一个选项,也可以指定 SQL 语句来执行 OLE DB 驱动程序。As an option, you can also specify a SQL statement to execute against the OLE DB driver.

以下列表详细介绍了通过使用泛型 OLE DB 接口,Power BI Desktop 可以连接到数据源的几个示例。The following list details a few examples of the data sources to which Power BI Desktop can connect by using the generic OLE DB interface.

Power BI Desktop 泛型连接器Power BI Desktop generic connector 外部数据源External data source 有关详细信息的链接Link for more information
OLE DBOLE DB SAS OLE DBSAS OLE DB SAS Provider for OLE DBSAS provider for OLE DB
OLE DBOLE DB Sybase OLE DBSybase OLE DB Sybase Provider for OLE DBSybase provider for OLE DB

数据源可以通过 OData 访问Data sources accessible through OData

Power BI Desktop 中的 OData 连接器可使你仅通过键入或粘贴 OData URL 即可从 OData URL 导入数据。The OData connector in Power BI Desktop lets you import data from any OData URL simply by typing in or pasting the OData URL. 可以通过键入或粘贴 OData 源窗口中提供的文本框中的这些链接来添加多个 URL 部分。You can add multiple URL parts by typing or pasting those links in the text boxes provided in the OData Feed window.

以下列表详细介绍了通过使用泛型 OData 接口,Power BI Desktop 可以连接到数据源的几个示例。The following list details a few examples of the data sources to which Power BI Desktop can connect by using the generic OData interface.

Power BI Desktop 泛型连接器Power BI Desktop generic connector 外部数据源External data source 有关详细信息的链接Link for more information
ODataOData 即将推出Coming soon OData 数据源即将推出Check back soon for OData data sources

数据源可通过 REST API 访问Data sources accessible through REST APIs

可使用 REST API 连接到数据源,因此,请使用支持 REST 的所有类型的数据源的数据。You can connect to data sources using the REST APIs and thereby use data from all sorts of data sources that support REST.

以下列表详细介绍了通过使用泛型 REST API 接口,Power BI Desktop 可以连接到数据源的几个示例。The following list details a few examples of the data sources to which Power BI Desktop can connect by using the generic REST APIs interface.

Power BI Desktop 泛型连接器Power BI Desktop generic connector 外部数据源External data source 有关详细信息的链接Link for more information
REST APIREST APIs Couchbase DBCouchbase DB Couchbase REST API 信息Couchbase REST API information

数据源可以通过 R 脚本访问Data sources accessible through R Script

可以使用 R 脚本访问数据源,并使用 Power BI Desktop 中的数据。You can use R scripts to access data sources, and use that data in Power BI Desktop.

以下列表详细介绍了通过使用泛型 R 脚本接口,Power BI Desktop 可以连接到数据源的几个示例。The following list details a few examples of the data sources to which Power BI Desktop can connect by using the generic R scripts interface.

Power BI Desktop 泛型连接器Power BI Desktop generic connector 外部数据源External data source 有关详细信息的链接Link for more information
R 脚本R Script SAS 文件SAS Files CRAN 的 R 脚本指南R script guidance from CRAN
R 脚本R Script SPSS 文件SPSS Files CRAN 的 R 脚本指南R script guidance from CRAN
R 脚本R Script R 统计文件R Statistical Files CRAN 的 R 脚本指南R script guidance from CRAN

后续步骤Next steps

可以使用 Power BI Desktop 连接到各种数据源。There are all sorts of data sources you can connect to using Power BI Desktop. 有关数据源的详细信息,请参阅下列资源:For more information on data sources, check out the following resources: