Azure Resource Graph x Power BI is finally here!
Published Nov 27 2023 11:13 AM 3,496 Views
Microsoft

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.

 

Onboarding & First Time Users 

Before digging into specific clients, we ask that you recognize what the ARG Power BI Connector looks like:

 

AllanaHudson_0-1701111562480.png

 

 

Prerequisites 

 Capabilities Supported 

  • Import
  • Advanced options 
    • Scope by subscription(s) and/or management group(s) 

How to Connect to ARG from Power Query Desktop 

  1. In Get Data, select Azure Resource Graph, and then select Connect. 
  2. In Azure Resource Graph dialog box, fill in the query and any optional fields, such as Scope. Check here for sample ARG queries. 
  3. If this attempt is the first time you're connecting to this site, select Sign in and input your credentials. Then select Connect. 
  4. In Navigator, select the tables you require, then either load or transform the data. 

 

How to Connect to ARG from Power Query Online 

  1. In Choose data source, search for Azure Resource Graph, and then select Azure Resource Graph. 
  2. In Connect to data source, fill in the query and any optional fields, such as Scope. 
  3. Sign into your organizational account. 
  4. When you've successfully signed in, select Next. 
  5. In Choose data, select the data you require, and then select Transform Data. 

 

Learn more about connecting to the ARG Power BI connector and its additional capabilities here.

 

Scenarios 

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.

Power State Breakdown of all VMs

 

Resources 
| where type == 'microsoft.compute/virtualmachines' 
| summarize count() by tostring(properties.extended.instanceView.powerState.code) 

 

List all non-compliance resources (based on your Azure Policy assignments) 

 

PolicyResources 
| where type == 'microsoft.policyinsights/policystates' 
| where properties.complianceState == 'NonCompliant' 
| extend NonCompliantResourceId = properties.resourceId, PolicyAssignmentName = properties.policyAssignmentName

 

View all tag keys and values across all resources, subscriptions, and management groups

 

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-"

 

 

Reach Us & Stay Updated

2 Comments
Version history
Last update:
‎Nov 27 2023 11:25 AM
Updated by: