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


   billingProject as text,
   optional options as nullable record,
) as table


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. //${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…].


List the available projects in Google BigQuery using Azure AD


Other functions related to GoogleBigQueryAad.Database are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot