使用 Power BI 連接到 Google Analytics (分析)Connect to Google Analytics with Power BI

透過 Power BI 連接到 Google Analytics 時,一開始會連接到您的 Google Analytics 帳戶。Connecting to Google Analytics through Power BI starts by connecting to your Google Analytics account. 您會看到 Power BI 儀表板和一組 Power BI 報表,供您深入了解網站流量和使用者維度。You will get a Power BI dashboard and a set of Power BI reports that provide insights about your site traffic and user dimensions. 您可以與儀表板和報表互動,但無法儲存變更。You can interact with the dashboard and reports, but you can't save changes. 資料會自動每天重新整理一次。The data will be refreshed automatically once per day.

連線到 Power BI 的 Google AnalyticsConnect to Google Analytics for Power BI. 深入了解 Google Analytics 與 Power BI 的整合Read more about the Google Analytics integration with Power BI.

您可以在 Power BI Desktop 中從 Google Analytics 連接器開始,建立自訂儀表板和報表。You can create customized dashboards and reports by starting from the Google Analytics connector in Power BI Desktop. 只需連線到 Google Analytics 帳戶,並建立可發行到 Power BI 服務的自訂報表。Just connect with your Google Analytics account and create your custom reports, which you can publish to the Power BI service.

如何連接How to connect

  1. 在左側的功能窗格中選取 [應用程式] > 選取右上角的 [取得應用程式]。Select Apps in the left navigation pane > select Get apps in the upper-right corner.

    [取得應用程式] 圖示

  2. 在 AppSource 中,選取 [應用程式] 索引標籤,然後搜尋您想要的服務。In AppSource, select the Apps tab, and search for the service you want.

    AppSource 中的 [應用程式] 索引標籤

  1. 選取 [Google Analytics (分析)] > [取得]。Select Google Analytics > Get.

  2. 出現提示時,請輸入您的 Google Analytics 認證。When prompted, enter your Google Analytics credentials. 選取 [oAuth 2] 做為驗證機制,然後按一下 [登入] 。Select oAuth 2 as the Authentication Mechanism and click Sign In. 請遵循 Google 驗證流程,如果您已經設定,其中可能包含雙因素驗證。Follow the Google authentication flow, which may include 2-factor authentication if you have it configured.

  3. 按一下 [接受] 允許 Power BI 存取 Google Analytics 資料。Click Accept to allow Power BI to access your Google Analytics data.

  4. Power BI 會連線到特定的 Google Analytics 檢視。Power BI connects to a specific Google Analytics View. 請選取帳戶名稱、屬性名稱和您想要連接的檢視名稱。Select the account name, property name and view name you’d like to connect to. 這項資訊可在您的 Google Analytics 帳戶中找到,位於左上方或在 [首頁] 索引標籤上。請參閱下列詳細資料。This information can be found in your Google Analytics account, either in the top left or on the Home tab. See details below.

  5. 按一下 [連接] 開始匯入程序。Click Connect to begin the import process.

檢視 Google Analytics 儀表板和報表View the Google Analytics dashboard and reports

匯入完成時,新的應用程式會出現在 [應用程式] 頁面上。When the import is complete, the new app will appear on the Apps page.

  1. 在左側功能窗格中選取 [應用程式] > 選取應用程式。Select Apps in the left navigation pane > select the app.

    左側功能窗格中的應用程式

  2. 您可以在問與答方塊中鍵入問題,或按一下圖格開啟基礎報表。You can ask a question by typing in the Q&A box, or click a tile to open the underlying report.
  ![](media/service-connect-to-google-analytics/googleanalytics2.png)

接下來呢?What now?

  • 請嘗試在儀表板頂端的問與答方塊中提問Try asking a question in the Q&A box at the top of the dashboard.
  • 選取圖格,開啟基礎報表。Select a tile to open the underlying report.
  • 您可以篩選和醒目提示報表中的資料,但無法儲存變更。You can filter and highlight the data in the report, but you can't save your changes.
  • 您的資料集已排定為每天重新整理。Your dataset is scheduled to refreshed daily. 您可以變更重新整理排程,或使用 [立即重新整理] 視需要嘗試重新整理。You can change the refresh schedule or try refreshing it on demand using Refresh Now.

系統需求System requirements

若要從 Power BI 連線,您必須先有 Google Analytics 帳戶。To connect from Power BI, you need to have a Google Analytics account. 其他未與 Google Analytics (分析) 帳戶連接的 Google 帳戶會看到驗證錯誤。Other Google accounts that do not have a Google Analytics account connected to it will see an authentication error.

疑難排解Troubleshooting

認證:如果您有多個 Google 帳戶,請在連接期間使用 incognito 或私用瀏覽器視窗,以確保使用正確的帳戶。Credentials If you have multiple Google accounts, please use an incognito or an in-private broswer window during connection to ensure the correct account is used.

如果您收到錯誤指出認證無效,但您仍可登入 Google,請確認您是否具有 Google Analytics (分析) 帳戶。If you're getting an error indicating your credentials are invalid however you were able to sign into Google, please confirm you have a Google Analytics account.

參數:目前參數需要唯一的名稱。Parameters Unique names are currently required for the parameters. 如果您看到錯誤,指出您選取的值重複,請選取另一個值,或變更 Google Analytics (分析) 中的名稱使其成為唯一。If you see an error indicating the value you selected is duplicated, please select another value or change the names in Google Analytics to make them unique. 我們正積極改善此問題。We're actively working to improve this.

注意

參數會區分大小寫。Parameters are case-sensitive. 請準確輸入出現在您 Google Analytics 帳戶中的參數。Enter them exactly as they appear in your Google Analytics account.

仍然有問題嗎?Still having issues? 請開啟支援票證,連絡 Power BI 小組:Open a support ticket to reach the Power BI team:

  • 請在 Power BI 應用程式中選取問號 > [連絡支援人員]。While in the Power BI app, select the question mark > Contact Support.
  • 從 Power BI 支援網站 (也就是您正在閱讀本文的位置) 中,選取頁面右側的 [連絡支援人員] 。From the Power BI Support site (where you're reading this article), select Contact Support on the right side of the page.

後續步驟Next steps