AzureResourceGraph.Query

Updated on

AzureResourceGraph.Query is a Power Query M function that runs queries against Azure Resource Graph and returns information about Azure resources.

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

Syntax

AzureResourceGraph.Query(
   query as text,
   optional scope as nullable text,
   optional subscription as nullable text,
   optional managementGroup as nullable text,
   optional options as nullable record,
) as table

Description

See https://learn.microsoft.com/azure/governance/resource-graph/samples/starter?tabs=azure-cli for starter query samples.

Examples

Return a table with query results of user query ‘resources’

AzureResourceGraph.Query( "resources" )
BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot