AzureHiveLLAP.Database is a Power Query M function that imports data from HDInsight Interactive Query and returns a list of tables. It allows customization of connection and command timeout.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
AzureHiveLLAP.Database(
server as text,
database as text,
optional options as nullable record,
) as table
Description
Returns a list of tables from HDInsight Interactive Query specified by the database
on the HDInsight Interactive Query server
. A port number may be optionally specified with the server, separated by a colon. An optional options
parameter 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 driver-dependent.CommandTimeout
: A duration which controls how long the server-side query is allowed to run before it is canceled. The default value is driver-dependent.
options
parameter is specified as [option1 = value1, option2 = value2…].
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy