CData Power BI Connector for Google BigQuery 2019 - Online Help
Questions / Feedback?

Getting Started

CData 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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0