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

Use Storage Api

CData Power BI Connector for Google BigQuery 2019 - Build 19.0.7354

Specifies whether to use BigQuery's Storage API for bulk data reads.

Data Type


Default Value



When this is set to true, the connector will use the Storage API instead of the default REST API. Depending upon the complexity of the query, the connector may execute the query in one of two ways:

  • Simple queries that read all columns from only one table, and have no extra clauses except LIMIT, are executed directly within the Storage API.
  • All other queries are executed as a query job which writes to a temporary table. Once the query is complete, the results are read from the temporary table using the Storage API.

The BigQuery Storage API can read data faster and more efficiently than the REST API, but is priced differently and requires extra OAuth permissions when using your own OAuth app. It also uses the separate StoragePageSize property instead of PageSize.

The BigQuery REST API requires no extra permissions and uses standard pricing, but is slower than the Storage API.

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