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 tableDescription
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
Examples
List the available projects in Google BigQuery
GoogleBigQuery.Database()Related articles
Learn more about GoogleBigQuery.Database in the following articles:
- Query Folding on Native Queries
This article delves into using Query Folding for Native Queries. It also provides a list of connectors that currently supports this. » Read more - Google Big Query Connector
This article provides information on the Google Big Query connector. » Read more
Related functions
Other functions related to GoogleBigQuery.Database are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy