Power BI on BigQuery

Panoply on BigQuery

To connect Power BI to BigQuery:

1. In Panoply, click on BI Connection in the top menu to view your connection details. These details will be needed in Step 4. Also make note of the Project ID, which will be needed in Step 8.
   

2. Open your PowerBI Desktop App. Click on Get Data or “Get data from another source”.
   

3. Type Google BigQuery in the search bar. Click Connect.
   

4. Under Organizational account, click on Sign in to connect your Google account to PowerBI.
   

5. You will be re-directed to Google Sign-In page.
   

6. You will be asked to authorize Power BI to access your Google Account. Click on Allow.
   

7. You will be re-directed to Power BI Desktop App. You have successfully added Google BigQuery as your Data Source. Click on Connect.
   

8. Look for your “project ID” under Google BigQuery. Click on Load to get started. This is the **Project ID **can be found in Step 1.
   

You have successfully connected PowerBI to your BigQuery data warehouse.