AzureDataExplorer.Contents

Azure Data Explorer (Kusto) and Fabric KQL databases: the databases on a cluster, the tables in a database, or the rows of a KQL query.

Group: Online services. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

AzureDataExplorer.Contents(cluster as text, optional database as nullable text, optional tableOrQuery as nullable text, optional options as nullable record) as table

Parameter	Type	Description
`cluster`	text	The cluster: its name (help, or help.westeurope) or its https:// address, a Fabric KQL database's too.
`database`	nullable text optional	A database of the cluster.
`tableOrQuery`	nullable text optional	A table's name, or a KQL query.
`options`	nullable record optional	Accepted as Power Query writes it; none is read.

Returns

table. A navigation table, or the table's or query's rows.

Remarks

With a cluster only: its databases (Name, Data, Kind "Database"). With a database: its tables (Name, Data, Kind "Table"). With a table or a query too: its rows.
A column's type is Kusto's: int and long Int64.Type, real and decimal number, bool logical, datetime a datetimezone, dynamic any, the others text.
The studio's preview asks for the first rows only.
Signed in with your Microsoft work account: the studio asks the first time this computer reads the source, and keeps the sign-in on this computer only.
Kusto.Contents is the same function under its other name.

Examples

A KQL query

AzureDataExplorer.Contents("norwayanalytics.westeurope", "Telemetry", "Events | where Timestamp > ago(7d) | summarize Count = count() by Shop")

Result: not shown here: it needs an Azure Data Explorer cluster and a sign-in.

A table by its name

AzureDataExplorer.Contents("https://norwayanalytics.westeurope.kusto.windows.net", "Telemetry", "Events")