AzureDataExplorer.Contents

Updated on

AzureDataExplorer.Contents is a Power Query M function that imports data from an Azure Data Explorer (Kusto) instance. The function returns the imported data from the Azure Data Explorer instance.

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

Syntax

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

Description

Imports data from your Azure Data Explorer (Kusto) instance

Examples

Returns a table of Storm Events information

// Output: A table with Storm Events from the "Samples" database in the "help" cluster
Kusto.Contents( "help", "Samples", "StormEvents", [] )

Other functions related to AzureDataExplorer.Contents are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot