GoogleBigQueryAad.Database

Updated on

GoogleBigQueryAad.Database is a Power Query M function that imports data from a Google BigQuery database using Azure AD, offering controls like ConnectionTimeout, CommandTimeout, UseStorageApi, and AudienceUri.

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

Syntax

GoogleBigQueryAad.Database(
   billingProject as text,
   optional options as nullable record,
) as table

Description

Returns a table listing the available projects in Google BigQuery using Azure AD for Billing Project ID . 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.
  • 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
  • AudienceUri: This is the audience URI which the ODBC driver can use for its token exchange requests. This field must be a fully qualified URI (i.e. //iam.googleapis.com/locations/global/workforcePools/${pool_id}/providers/azuread) where pool_id is a globally-unique name to identify the workforce pool.
The record parameter is specified as [option1 = value1, option2 = value2…].

Examples

List the available projects in Google BigQuery using Azure AD

GoogleBigQueryAad.Database()

Other functions related to GoogleBigQueryAad.Database are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot