Azure Resource Graph x Power BI is finally here!

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:

[ATTACH=full]56889[/ATTACH]

Prerequisites

• An Azure subscription. Go to Get Azure free trial.
  
• You must have appropriate rights in Azure role-based access control (Azure RBAC) with at least read access to the resources you want to query.
  

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.
   

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

• For questions and direct feedback with this feature, you can reach us at Azure Resource Graph PMs (argpms@microsoft.com)
  
• Share Product feedback and ideas with us at Azure Governance · Community
  
• For announcements, please bookmark the Azure Governance Tech Community Blog and then follow us @AzureGovernance on X (previously known as Twitter)
  

Continue reading...