Spark.Tables

Spark.Tables is a Power Query M function that returns a table listing the tables on the specified Spark cluster.

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

Syntax

Spark.Tables(
   server as text,
   protocol as number,
   optional options as nullable record,
) as table

Description

Returns a table listing the tables on the Spark cluster host using protocol. Valid protocols are: SparkProtocol.Standard, SparkProtocol.Azure, SparkProtocol.HTTP

Examples

List the tables in an Azure Spark instance.

Spark.Tables( "contoso.azurehdinsight.net", SparkProtocol.Azure )

Contribute » | Contributors: Rick de Groot