Azure Resource Graph (ARG) team is proud to announce the Public Preview of our ARG Power BI Data Connector. Now, you can seamlessly transform your Azure Resource Graph queries into stunning visualizations within Power BI. Elevate your analytics game and make data-driven decisions with ease.
Unlock the synergy of Azure Resource Graph and Power BI in Power BI Datasets (Desktop + Service), Power BI Dataflow and Fabric Dataflow Gen 2! This has been the most requested feature of Azure Resource Graph since 2020, and we are proud to finally put it in your hands.
Before digging into specific clients, we ask that you recognize what the ARG Power BI Connector looks like:
Prerequisites
Capabilities Supported
How to Connect to ARG from Power Query Desktop
How to Connect to ARG from Power Query Online
Learn more about connecting to the ARG Power BI connector and its additional capabilities here. |
The following sections below are some queries that you can visualize in Power BI to have more insight into your organization’s resources and governance state.
Resources
| where type == 'microsoft.compute/virtualmachines'
| summarize count() by tostring(properties.extended.instanceView.powerState.code)
PolicyResources
| where type == 'microsoft.policyinsights/policystates'
| where properties.complianceState == 'NonCompliant'
| extend NonCompliantResourceId = properties.resourceId, PolicyAssignmentName = properties.policyAssignmentName
ResourceContainers
| where isnotempty(tags)
| project tags
| mvexpand tags
| extend tagKey = tostring(bag_keys(tags)[0])
| extend tagValue = tostring(tags[tagKey])
| union (
resources
| where isnotempty(tags)
| project tags
| mvexpand tags
| extend tagKey = tostring(bag_keys(tags)[0])
| extend tagValue = tostring(tags[tagKey])
)
| distinct tagKey, tagValue
| where tagKey !startswith "hidden-"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.