Updated on

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


   server as text,
   database as text,
   optional options as nullable record,
) as table


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.
The options parameter is specified as [option1 = value1, option2 = value2…].

Contribute » | Contributors: Rick de Groot