Getting StartedCData Power BI Connector for Google BigQuery 2019 - Build 19.0.7354
The CData Power BI Connector for Google BigQuery 2019 is built on top of an ODBC driver. This section discusses how to install the connector, create a DSN, and connect from Power BI.
Installing the Connector
Installing the Connector describes how to install the CData Power BI Connector for Google BigQuery 2019.
Creating a Data Source Name (DSN)
Creating the Data Source Name describes the process to authenticate and connect to Google BigQuery
Connecting from Power BI
Getting Data shows how to connect to the DSN and build a query to Google BigQuery from the Get Data window.
Google BigQuery Version Support
The connector enables read/write SQL-92 access to the BigQuery tables in your Google account or Google Apps domain. The complete aggregate and join syntax in BigQuery is supported. Additionally, statements in the BigQuery syntax can be passed through. The connector uses version 2.0 of the BigQuery Web services API: You must enable this API by creating a project in the Google Developers Console. See Connecting to Google for a guide to creating a project and authenticating to this API.