Power BI Desktop 中的資料來源Data sources in Power BI Desktop

有了 Power BI Desktop,您可以從許多不同來源連接至資料。With Power BI Desktop, you can connect to data from many different sources. 在此頁面底部有可用資料來源的完整清單。A full list of available data sources is at the bottom of this page.

若要連接到資料,請從 [主資料夾] 功能區選取 [取得資料] 。To connect to data, select Get Data from the Home ribbon. 選取向下箭號,或按鈕上的 [取得資料] 文字,會顯示 [最常見] 資料類型功能表,如下圖所示。Selecting the down arrow, or the Get Data text on the button, shows the Most Common data types menu shown in the following image.

選取 [其他...],Selecting More… 該選項來自 [最常見] 功能表,如此即會顯示 [取得資料] 視窗。from the Most Common menu displays the Get Data window. 您也可以藉由直接選取 [取得資料] 圖示按鈕,叫出 [取得資料] 視窗 (並略過 [最常見] 功能表)。You can also bring up the Get Data window (and bypass the Most Common menu) by selecting the Get Data icon button directly.

注意

Power BI 小組會持續將可用的資料來源擴充到 Power BI DesktopPower BI 服務The Power BI team is continually expanding the data sources available to Power BI Desktop and the Power BI service. 因此,您經常會看到舊版工作進行中的資料來源標示為 Beta 或「預覽」。As such, you'll often see early versions of work-in-progress data sources marked as Beta or Preview. 任何標示為 Beta 或「預覽」的資料來源,受到的支援和功能都有限制,不應該用在生產環境。Any data source marked as Beta or Preview has limited support and functionality, and should not be used in production environments.

資料來源Data Sources

資料類型會組織成下列類別:Data types are organized in the following categories:

  • 全部All
  • 檔案File
  • 資料庫Database
  • AzureAzure
  • 線上服務Online Services
  • 其他Other

[全部] 類別包含所有類別的所有資料連線類型。The All category includes all data connection types from all categories.

[檔案] 類別提供下列資料連線:The File category provides the following data connections:

  • ExcelExcel
  • Text/CSVText/CSV
  • XMLXML
  • JSONJSON
  • 資料夾Folder
  • SharePoint 資料夾SharePoint Folder

下圖顯示 [檔案] 的 [取得資料] 視窗。The following image shows the Get Data window for File.

注意

在舊版的 Power BI Desktop 中,CSV文字為不同的資料連線類型。In previous versions of Power BI Desktop, CSV and Text were separate data connection types. 這兩個資料連接器已合併為 CSV/文字Those data connectors have been combined into CSV/Text.

[資料庫] 類別提供下列資料連線:The Database category provides the following data connections:

  • SQL Server 資料庫SQL Server Database
  • Access 資料庫Access Database
  • SQL Server Analysis Services 資料庫SQL Server Analysis Services Database
  • Oracle 資料庫Oracle Database
  • IBM DB2 資料庫IBM DB2 Database
  • IBM Informix 資料庫 (搶鮮版 (Beta))IBM Informix database (Beta)
  • IBM Netezza (Beta)IBM Netezza (Beta)
  • MySQL 資料庫MySQL Database
  • PostgreSQL 資料庫PostgreSQL Database
  • Sybase 資料庫Sybase Database
  • Teradata 資料庫Teradata Database
  • SAP HANA 資料庫SAP HANA Database
  • SAP Business Warehouse 伺服器SAP Business Warehouse server
  • Amazon RedshiftAmazon Redshift
  • ImpalaImpala
  • Google BigQuery (搶鮮版 (Beta))Google BigQuery (Beta)
  • 雪花式Snowflake

注意

某些資料庫連接器的啟用方式為選取 [檔案] > [選項和設定] > [選項],然後選取 [預覽功能] 並啟用該連接器。Some database connectors require that you enable them by selecting File > Options and settings > Options then selecting Preview Features and enabling the connector. 如果您沒有看到上述連接器,但想要加以使用,請檢查您的 [預覽功能] 設定。If you don't see some of the connectors mentioned above and want to use them, check your Preview Features settings. 亦請注意,任何標示為 Beta 或「預覽」的資料來源,受到的支援和功能都有限制,不應該用在生產環境。Also note that any data source marked as Beta or Preview has limited support and functionality, and should not be used in production environments.

下圖顯示 [資料庫] 的 [取得資料] 視窗。The following image shows the Get Data window for Database.

[Azure] 類別提供下列資料連線:The Azure category provides the following data connections:

  • Azure SQL DatabaseAzure SQL Database
  • Azure SQL 資料倉儲Azure SQL Data Warehouse
  • Azure Analysis Services 資料庫 (搶鮮版 (Beta))Azure Analysis Services database (Beta)
  • Azure Blob 儲存體Azure Blob Storage
  • Azure 表格儲存體Azure Table Storage
  • Azure Cosmos DB (搶鮮版 (Beta))Azure Cosmos DB (Beta)
  • Azure Data Lake StoreAzure Data Lake Store
  • Azure HDInsight (HDFS)Azure HDInsight (HDFS)
  • Azure HDInsight Spark (Beta)Azure HDInsight Spark (Beta)

下圖顯示 [Azure] 的 [取得資料] 視窗。The following image shows the Get Data window for Azure.

[線上服務] 類別提供下列資料連線:The Online Services category provides the following data connections:

  • Power BI 服務Power BI service
  • SharePoint Online 清單SharePoint Online List
  • Microsoft Exchange OnlineMicrosoft Exchange Online
  • Dynamics 365 (線上)Dynamics 365 (online)
  • Dynamics 365 for Financials (搶鮮版 (Beta))Dynamics 365 for Financials (Beta)
  • Common Data Service (搶鮮版 (Beta))Common Data Service (Beta)
  • Microsoft Azure Consumption Insights (搶鮮版 (Beta))Microsoft Azure Consumption Insights (Beta)
  • Visual Studio Team Services (Beta)Visual Studio Team Services (Beta)
  • Salesforce 物件Salesforce Objects
  • Salesforce 報表Salesforce Reports
  • Google Analytics (分析)Google Analytics
  • appFigures (Beta)appFigures (Beta)
  • comScore Digital Analytix (Beta)comScore Digital Analytix (Beta)
  • Dynamics 365 for Customer Insights (Beta)Dynamics 365 for Customer Insights (Beta)
  • FacebookFacebook
  • GitHub (Beta)GitHub (Beta)
  • Kusto (搶鮮版 (Beta))Kusto (Beta)
  • MailChimp (Beta)MailChimp (Beta)
  • Mixpanel (搶鮮版 (Beta))Mixpanel (Beta)
  • Planview Enterprise (Beta)Planview Enterprise (Beta)
  • Projectplace (搶鮮版 (Beta))Projectplace (Beta)
  • QuickBooks Online (Beta)QuickBooks Online (Beta)
  • SmartsheetSmartsheet
  • SparkPost (Beta)SparkPost (Beta)
  • SQL Sentry (Beta)SQL Sentry (Beta)
  • Stripe (搶鮮版 (Beta))Stripe (Beta)
  • SweetIQ (Beta)SweetIQ (Beta)
  • Troux (Beta)Troux (Beta)
  • Twilio (Beta)Twilio (Beta)
  • tyGraph (Beta)tyGraph (Beta)
  • Webtrends (Beta)Webtrends (Beta)
  • Zendesk (Beta)Zendesk (Beta)

下圖顯示 [線上服務] 的 [取得資料] 視窗。The following image shows the Get Data window for Online Services.

[其他] 類別提供下列資料連線:The Other category provides the following data connections:

  • Vertica (搶鮮版 (Beta))Vertica (Beta)
  • WebWeb
  • SharePoint 清單SharePoint List
  • OData 摘要OData Feed
  • Active DirectoryActive Directory
  • Microsoft ExchangeMicrosoft Exchange
  • Hadoop 檔案 (HDFS)Hadoop File (HDFS)
  • Spark (Beta)Spark (Beta)
  • R ScriptR Script
  • ODBCODBC
  • OLE DBOLE DB
  • 空白查詢Blank Query

下圖顯示 [其他] 的 [取得資料] 視窗。The following image shows the Get Data window for Other.

注意

目前無法連線至使用 Azure Active Directory 保護的自訂資料來源。At this time, it's not possible to connect to custom data sources secured using Azure Active Directory.

連接到資料來源Connecting to a Data Source

若要連接至資料來源,請從 [取得資料] 視窗選取資料來源,然後選取 [連接] 。To connect to a data source, select the data source from the Get Data window and select Connect. 在下圖中,從 [其他] 資料連線類別選取了 [Web] 。In the following image, Web is selected from the Other data connection category.

隨即會顯示資料連線類型特有的連線視窗。A connection window is displayed, specific to the type of data connection. 如果需要認證,將提示您提供它們。If credentials are required, you’ll be prompted to provide them. 下圖顯示輸入 URL 以連接到 Web 資料來源。The following image shows a URL being entered to connect to a Web data source.

輸入 URL 或資源連線資訊之後,請選取 [確定] 。When the URL or resource connection information is entered, select OK. Power BI Desktop 會建立資料來源的連線,並在 [導覽器] 中呈現可用的資料來源。Power BI Desktop makes the connection to the data source, and presents the available data sources in the Navigator.

您可以選取 [導覽器] 窗格底部的 [載入] 按鈕來載入資料,或是選取 [編輯] 按鈕,在載入資料之前先編輯查詢。You can either load the data by selecting the Load button at the bottom of the Navigator pane, or edit the query before loading data by selecting the Edit button.

這就是連接到 Power BI Desktop 中資料來源的全部資訊!That’s all there is to connecting to data sources in Power BI Desktop! 嘗試連接到我們持續增加的資料來源,並經常回來查看,我們隨時會增加新的來源。Try connecting to data from our growing list of data sources, and check back often - we continue to add to this list all the time.

後續步驟Next steps

您可以使用 Power BI Desktop 執行各種作業。There are all sorts of things you can do with Power BI Desktop. 如需有關其功能的詳細資訊,請參閱下列資源:For more information on its capabilities, check out the following resources: