在 Power BI Desktop 中連線至 Amazon RedshiftConnect to Amazon Redshift in Power BI Desktop

Power BI Desktop 中,您可以連接至 Amazon Redshift 資料庫並使用基礎資料,就像 Power BI Desktop 中的任何其他資料來源。In Power BI Desktop, you can connect to an Amazon Redshift database and use the underlying data just like any other data source in Power BI Desktop.

連接到 Amazon Redshift 資料庫Connect to an Amazon Redshift database

若要連線至 Amazon Redshift 資料庫,請從 Power BI Desktop 的 [首頁] 功能區選取 [取得資料]。To connect to an Amazon Redshift database select Get Data from the Home ribbon in Power BI Desktop. 從左側類別中選取 [資料庫],您就會看到 [Amazon Redshift]。Select Database from the categories on the left, and you see Amazon Redshift.

在出現的 Amazon Redshift 視窗中,將您的 Amazon Redshift 伺服器及資料庫名稱鍵入或貼上方塊中。In the Amazon Redshift window that appears, type or paste the name of your Amazon Redshift server and database into the box. 在 [伺服器] 欄位中,使用者可以用下列格式指定連接埠作為其一部分︰ServerURL:PortAs part of the Server field, users can specify a ort in the following format: ServerURL:Port

收到提示時,請放入您的使用者名稱和密碼。When prompted, put in your username and password.

成功連接後,[導覽器] 視窗隨即出現,並顯示伺服器上可用的資料,您可以從中選取一或多個要匯入 Power BI Desktop 並在其中使用的項目。Once you successfully connect, a Navigator window appears and displays the data available on the server, from which you can select one or multiple elements to import and use in Power BI Desktop.

當您在 [導覽器] 視窗完成選取後,就可以 [匯入] 或 [編輯] 資料。Once you make selections from the Navigator window, you can either Load or Edit the data.

  • 如果選擇 [載入] 資料,系統會提示您要使用 [匯入] 或 [DirectQuery] 模式載入資料。If you choose to Load data, you'll prompted wither to use Import or DirectQuery mode to load the data. 如需詳細資訊,請查看這篇說明 DirectQuery 的文章For more information, check out this article that explains DirectQuery.
  • 如果選擇 [編輯] 資料,Query Editor隨即顯示,您可以從中將各種轉換及篩選條件套用到資料,其中有多種適用於基礎 Amazon Redshift 本身 (如受支援)。If you select to Edit the data, Query Editor appears where you can apply all sorts of transformations and filters to the data, many of which are applied to the underlying Amazon Redshift database itself (if supported).

後續步驟Next steps

您可以使用 Power BI Desktop 連接至各式各樣的資料。There are all sorts of data you can connect to using Power BI Desktop. 如需有關資料來源的詳細資訊,請參閱下列資源︰For more information on data sources, check out the following resources: