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:

在 Power BI Desktop 中取得資料

選取 [其他...] ,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.

此外,任何為 Power BI Desktop 標記為「搶鮮版 (Beta)」 或「預覽」 的資料來源都無法在正式推出 (GA) 前於 Power BI 服務或其他 Microsoft 服務中使用。Additionally, any data source marked as Beta or Preview for Power BI Desktop may not be available for use in the Power BI service or other Microsoft services until the data source becomes generally available (GA).

資料來源Data Sources

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

  • 全部All
  • 檔案File
  • 資料庫Database
  • Power BIPower BI
  • 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
  • PDFPDF
  • SharePoint 資料夾SharePoint Folder

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

[取得資料] > [檔案]

[資料庫] 類別提供下列資料連線: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 NetezzaIBM Netezza
  • MySQL 資料庫MySQL Database
  • PostgreSQL 資料庫PostgreSQL Database
  • Sybase 資料庫Sybase Database
  • TeradataTeradata
  • SAP HANA 資料庫SAP HANA Database
  • SAP Business Warehouse 應用程式伺服器SAP Business Warehouse Application Server
  • SAP Business Warehouse 訊息伺服器SAP Business Warehouse Message Server
  • Amazon RedshiftAmazon Redshift
  • ImpalaImpala
  • Google BigQueryGoogle BigQuery
  • VerticaVertica
  • SnowflakeSnowflake
  • EssbaseEssbase
  • AtScale cube 搶鮮版 (Beta)AtScale cubes (Beta)
  • BI 連接器BI Connector
  • DremioDremio
  • ExasolExasol
  • Indexima (搶鮮版 (Beta))Indexima (Beta)
  • InterSystems IRIS (搶鮮版 (Beta))InterSystems IRIS (Beta)
  • Jethro (搶鮮版 (Beta))Jethro (Beta)
  • Kyligence Enterprise (搶鮮版 (Beta))Kyligence Enterprise (Beta)
  • MarkLogic 搶鮮版 (Beta)MarkLogic (Beta)

注意

某些資料庫連接器的啟用方式為選取 [檔案] > [選項和設定] > [選項] ,然後選取 [預覽功能] 並啟用該連接器。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.

[取得資料] > [資料庫]

Power Platform 類別提供下列資料連線:The Power Platform category provides the following data connections:

  • Power BI 資料集Power BI datasets
  • Power BI 資料流程Power BI dataflows
  • Common Data ServiceCommon Data Service
  • Power Platform 資料流程 (搶鮮版 (Beta))Power Platform dataflows (Beta)

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

[取得資料] > [Power BI]

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

  • Azure SQL DatabaseAzure SQL Database
  • Azure SQL 資料倉儲Azure SQL Data Warehouse
  • Azure Analysis Services 資料庫Azure Analysis Services database
  • Azure Blob 儲存體Azure Blob Storage
  • Azure 表格儲存體Azure Table Storage
  • Azure Cosmos DBAzure Cosmos DB
  • Azure Data Lake Storage Gen2 (搶鮮版 (Beta))Azure Data Lake Storage Gen2 (Beta)
  • Azure Data Lake Storage Gen1Azure Data Lake Storage Gen1
  • Azure HDInsight (HDFS)Azure HDInsight (HDFS)
  • Azure HDInsight SparkAzure HDInsight Spark
  • HDInsight 互動式查詢HDInsight Interactive Query
  • Azure 資料總管 (Kusto)Azure Data Explorer (Kusto)
  • Azure 成本管理 (搶鮮版 (Beta))Azure Cost Management (Beta)

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

[取得資料] > [Azure]

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

  • SharePoint Online 清單SharePoint Online List
  • Microsoft Exchange OnlineMicrosoft Exchange Online
  • Dynamics 365 (線上)Dynamics 365 (online)
  • Dynamics NAVDynamics NAV
  • Microsoft Dynamics 365 Business CentralDynamics 365 Business Central
  • Dynamics 365 Business Central (內部部署)Dynamics 365 Business Central (on-premises)
  • Microsoft Azure 使用量見解 (搶鮮版 (Beta))Microsoft Azure Consumption Insights (Beta)
  • Azure DevOps (Beta)Azure DevOps (Beta)
  • Azure DevOps Server (Beta)Azure DevOps Server (Beta)
  • Salesforce 物件Salesforce Objects
  • Salesforce 報表Salesforce Reports
  • Google AnalyticsGoogle Analytics
  • Adobe AnalyticsAdobe Analytics
  • appFigures (搶鮮版 (Beta))appFigures (Beta)
  • Data.World - 取得資料集 (搶鮮版 (Beta))Data.World - Get Dataset (Beta)
  • FacebookFacebook
  • GitHub (Beta)GitHub (Beta)
  • MailChimp (Beta)MailChimp (Beta)
  • Merketo (Beta)Marketo (Beta)
  • Mixpanel (搶鮮版 (Beta))Mixpanel (Beta)
  • Planview Enterprise One - PRM (搶鮮版 (Beta))Planview Enterprise One - PRM (Beta)
  • Planview Projectplace (搶鮮版 (Beta))Planview Projectplace (Beta)
  • QuickBooks Online (搶鮮版 (Beta))QuickBooks Online (Beta)
  • SmartsheetSmartsheet
  • SparkPost (搶鮮版 (Beta))SparkPost (Beta)
  • Stripe (搶鮮版 (Beta))Stripe (Beta)
  • SweetIQ (搶鮮版 (Beta))SweetIQ (Beta)
  • Planview Enterprise One - CMT (搶鮮版 (Beta))Planview Enterprise One - CMT (Beta)
  • Twilio (搶鮮版 (Beta))Twilio (Beta)
  • tyGraph (Beta)tyGraph (Beta)
  • Webtrends (Beta)Webtrends (Beta)
  • Zendesk (搶鮮版 (Beta))Zendesk (Beta)
  • Dynamics 365 Customer Insights (搶鮮版 (Beta))Dynamics 365 Customer Insights (Beta)
  • Emigo 資料來源 搶鮮版 (Beta)Emigo Data Source (Beta)
  • Entersoft 商務套件 (搶鮮版 (Beta))Entersoft Business Suite (Beta)
  • 企業 App StoreIndustrial App Store
  • Intune 資料倉儲 (搶鮮版 (Beta))Intune Data Warehouse (Beta)
  • Microsoft Graph 安全性 搶鮮版 (Beta)Microsoft Graph Security (Beta)
  • Quick BaseQuick Base
  • TeamDesk (搶鮮版 (Beta))TeamDesk (Beta)

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

[取得資料] > [線上服務]

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

  • WebWeb
  • SharePoint 清單SharePoint List
  • OData 摘要OData Feed
  • Active DirectoryActive Directory
  • Microsoft ExchangeMicrosoft Exchange
  • Hadoop 檔案 (HDFS)Hadoop File (HDFS)
  • SparkSpark
  • R ScriptR Script
  • Python 指令碼Python script
  • ODBCODBC
  • OLE DBOLE DB
  • BI360 - Budgeting & Financial Reporting (搶鮮版 (Beta))BI360 - Budgeting & Financial Reporting (Beta)
  • DenodoDenodo
  • Information Grid (搶鮮版 (Beta))Information Grid (Beta)
  • PaxataPaxata
  • QubolePresto (搶鮮版 (Beta))QubolePresto (Beta)
  • Roamler (搶鮮版 (Beta))Roamler (Beta)
  • SurveyMonkey 搶鮮版 (Beta)SurveyMonkey (Beta)
  • Tenforce (Smart)List (搶鮮版 (Beta))Tenforce (Smart)List (Beta)
  • Workforce Dimensions (搶鮮版 (Beta))Workforce Dimensions (Beta)
  • 空白查詢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.

連線到 Web

隨即會顯示資料連線類型特有的連線視窗。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.

輸入 Web URL

輸入 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: