ODBC TUTORIAL

How to Build Power BI Reports on Google BigQuery Data using the DataDirect Google BigQuery Driver for ODBC

Updated: 04 Jan 2023

Introduction

Progress DataDirect’s ODBC Driver for Google BigQuery offers a high-performing, secure and reliable connectivity solution for ODBC applications to access Google BigQuery data. Our ODBC driver can be easily used with SQL across all platforms - Unix / Linux, AIX, Solaris, Windows, and HP-UX. Enjoy real-time analytics, reporting, and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE, and more. In this article, you will see how you can use Progress DataDirect ODBC drivers to build Power BI reports on Google BigQuery Data with Progress DataDirect Google BigQuery ODBC driver.     

 

Prerequisites

This tutorial assumes that you have ODBC drivers installed and a data source configured. If you have not yet done these steps, please follow these instructions: 

 

  1. 1. Download and install the Progress DataDirect Google BigQuery ODBC driver for your database using the 15-day trial software. In this tutorial, we are connecting to Google BigQuery. 

 

  1. 2. Configure a data source for your database. See the DataDirect documentation for assistance with setting up your data source. The sample below uses a data source. 

Configure Connection to Google BigQuery Driver Using the ODBC Data Source Administrator

  1. 1. After the DataDirect Google BigQuery ODBC driver has been installed, open ODBC Administrator to configure the connection and click on Add. 

 

 

 

  1. 2. Choose the “DataDirect X.X Google BigQuery” driver and click on “Finish. 

 

 

 

  1. 3. You should now see the ODBC Google BigQuery Driver Setup pop-up window launched. 

 

 

 

  1. 4. Add your Data Source Name, project, dataset, and other credentials, and click on “Apply and then “Test Connect.” 

 

 

 

  1. 5. A pop-up window will confirm that the connection is established. 

 

 

Connecting to an ODBC Data Source using DataDirect Google BigQuery ODBC driver

1. In Power BI, click on Get Data > More > All > ODBC. Choose it and you should now see a form as shown below where it will ask for the DSN name.  

 

2. Select the “DSN”. Choose the data source from the dropdown list, that has been previously configured to connect to Google BigQuery, and click on “OK.” 

Graphical user interface, application

Description automatically generated 

 

  1. 3. Authenticate using your credentials under Database and click on Connect. 

 

 

 

  1. 4. Choose your database, select table, and click on Load to continue. 

Graphical user interface, application

Description automatically generated 

  1. 5. You should now see your data in Power BI as shown below: