Connecting Microsoft Power BI to Hevo

Refer to this section to connect Microsoft Power BI to your managed BigQuery data warehouse.

Prerequisites

  • Windows 10, Windows Server 2012 R2, Windows Server 2008 R2, Windows Server 2012, Windows 7, Windows 8, or Windows 8.1 32-bit (x86) and 64-bit (x64) platform.
  • Internet Explorer 10 or higher, to run Microsoft Power BI Desktop.
  • Microsoft Power BI Desktop application.
  • Microsoft Power BI connection settings downloaded from Hevo.

Steps

  1. Log in to your Power BI Desktop application using your Microsoft account credentials. Alternatively, create your account now.

  2. In the Power BI Desktop page, click Get Data in the left pane.

    Power BI Get Data option

  3. In the Get Data page, click Database in the left pane, and from the list that is displayed, select Google BigQuery, and click Connect.

    Connect to BigQuery

  4. In the Google BigQuery dialog, click Sign in to connect to your managed BigQuery data warehouse.

    Sign-in

  5. Log in with your Google account.

  6. In the Sign in with Google page, click Allow to enable Power BI to access your managed BigQuery data.

    Authorize Power BI

  7. Specify the following:
    1. Project: The Project ID mentioned in the connection settings downloaded from Hevo.

    2. Dataset: The Dataset ID mentioned in the connection settings downloaded from Hevo.

  8. In Connection Settings, select Import as the Data Connectivity mode:

    Data connection mode

  9. The list of tables within your dataset are displayed in the Navigator. Select the tables you require and click Load.

    Project and dataset selection

    * The values provided in the image are indicative.

Last updated on 08 Oct 2020