在 Power BI Desktop 中使用泛型介面連接到資料Connect to data using generic interfaces in Power BI Desktop

您可以使用內建資料連接器,在 Power BI Desktop 中連接到多種不同的資料來源,連接器會顯示在 [取得資料] 視窗中,從 Access 資料庫Zendesk 資源皆涵蓋在內。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. 您也可以選擇指定要對 ODBC 驅動程式執行的 SQL 陳述式。As an option, you can also specify a SQL statement to execute against the ODBC driver.

下列清單詳列了幾個 Power BI Desktop可以使用泛型 ODBC 介面來連接的資料來源範例。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. 您也可以選擇指定要對 OLE DB 驅動程式執行的 SQL 陳述式。As an option, you can also specify a SQL statement to execute against the OLE DB driver.

下列清單詳列了幾個 Power BI Desktop可以使用泛型 OLE DB 介面來連接的資料來源範例。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 OLE DB 的 SAS 提供者SAS provider for OLE DB
OLE DBOLE DB Sybase OLE DBSybase OLE DB OLE DB 的 Sybase 提供者Sybase 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.

下列清單詳列了幾個 Power BI Desktop可以使用泛型 ata 介面來連接的資料來源範例。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.

下列清單詳列了幾個 Power BI Desktop可以使用泛型 REST API 介面來連接的資料來源範例。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.

下列清單詳列了幾個 Power BI Desktop可以使用泛型 R 指令碼介面來連接的資料來源範例。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 ScriptR Script SAS 檔案SAS Files CRAN 提供的 R 指令碼指導R script guidance from CRAN
R ScriptR Script SPSS 檔案SPSS Files CRAN 提供的 R 指令碼指導R script guidance from CRAN
R ScriptR 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: