GoogleBigQuery.Database

Updated on

GoogleBigQuery.Database is a Power Query M function that imports data from a Google BigQuery database, offering various controls including ConnectionTimeout, CommandTimeout, BillingProject, and UseStorageApi.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

GoogleBigQuery.Database( optional options as nullable record ) as table

Description

Returns a table listing the available projects in Google BigQuery. An optional record parameter, options, may be specified to control the following options:

  • ConnectionTimeout: A duration which controls how long to wait before abandoning an attempt to make a connection to the server. The default value is ODBC Connection Timeout value.
  • CommandTimeout: A duration which controls how long the server-side query is allowed to run before it is canceled.
  • BillingProject: Billing project id. The default value is the first available project.
  • UseStorageApi: Specifies whether to use the BigQuery Storage API for large result sets. The default value is true to use Storage API. Set to false to not use Storage API
The record parameter is specified as [option1 = value1, option2 = value2…].

Examples

List the available projects in Google BigQuery

GoogleBigQuery.Database()

Learn more about GoogleBigQuery.Database in the following articles:

Other functions related to GoogleBigQuery.Database are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot