在 Power BI Desktop 中連接到 SnowflakeConnect to Snowflake in Power BI Desktop

在 Power BI Desktop 中,您可以連接至 Snowflake 運算倉儲並使用基礎資料,就像 Power BI Desktop 中的任何其他資料來源。In Power BI Desktop, you can connect to a Snowflake computing warehouse and use the underlying data just like any other data source in Power BI Desktop.

注意

您還「必須」使用符合 Power BI Desktop 安裝的 32 位元或 64 位元架構,在使用 Snowflake 連接器的電腦上安裝 Snowflake ODBC 驅動程式You also must install the Snowflake ODBC driver on computers that use the Snowflake connector, using the architecture that matches the installation of Power BI Desktop, either 32-bit or 64-bit. 只要遵循下列連結並下載適當的 Snowflake ODBC 驅動程式即可。Just follow the following link and download the appropriate Snowflake ODBC driver.

連接至 Snowflake 運算倉儲Connect to a Snowflake computing warehouse

若要連接到 Snowflake 運算倉儲,請從 Power BI Desktop 的 [首頁] 功能區選取 [取得資料]。To connect to a Snowflake computing warehouse select Get Data from the Home ribbon in Power BI Desktop. 從左側類別中選取 [資料庫],然後您會看到 SnowflakeSelect Database from the categories on the left, and you see Snowflake.

在顯示的 [Snowflake] 視窗中,將您的 Snowflake 伺服器名稱鍵入或貼上方塊中,然後選取 [確定]。In the Snowflake window that appears, type or paste the name of your Snowflake computing warehouse into the box and select OK. 請注意,您可以選擇直接將資料 [匯入] Power BI 中,也可以使用 [DirectQuery]。Note that you can choose to Import data directly into Power BI, or you can use DirectQuery. 您可以深入了解如何使用 DirectQueryYou can learn more about using DirectQuery.

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

注意

一旦您在特定 Snowflake 伺服器放入使用者名稱和密碼,Power BI Desktop 便會在後續連接嘗試中使用與其相同的認證。Once you put in your username and password for a particular Snowflake server, Power BI Desktop uses those same credentials in subsequent connection attempts. 您可以前往 [檔案] > [選像和設定] > [資料來源設定] 修改認證。You can modify those credentials by going to File > Options and settings > Data source settings.

成功連接後,[導覽器] 視窗隨即出現,並顯示伺服器上可用的資料,您可以從中選取一或多個要匯入 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.

您可以載入選取的資料表,將整個資料表帶入 Power BI Desktop 中,也可以編輯查詢以開啟查詢編輯器,以便您篩選並縮小搜尋範圍到一組您想要使用的資料,然後將該組精簡的資料載入 Power BI Desktop 中。You can Load the selected table, which brings the entire table into Power BI Desktop, or you can Edit the query, which opens Query Editor so you can filter and refine the set of data you want to use, and then load that refined set of data into Power BI Desktop.

後續步驟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: