Quickstart: Run queries with the Azure Resource Graph Power BI connector

In this quickstart, you learn how to run queries with the Azure Resource Graph Power BI connector. By default the Power BI connector runs queries at the tenant level but you can change the scope to subscription or management group. Azure Resource Graph by default returns a maximum of 1,000 records but the Power BI connector has an optional setting to return all records if your query results have more than 1,000 records.

Note

The Azure Resource Graph Power BI connector is in public preview.

Tip

If you participated in the private preview, delete your AzureResourceGraph.mez preview file. If the file isn't deleted, your custom connector might be used by Power Query instead of the certified connector.

Prerequisites

• If you don't have an Azure account with an active subscription, create a free account before you begin.
• Power BI Desktop or a Power BI service workspace in your organization's tenant.
• Azure role-based access control rights with at least Reader role assignment to resources. To learn more about role assignments, go to Assign Azure roles using the Azure portal.

Connect Azure Resource Graph with Power BI connector

You can run queries with Power BI Desktop or Power BI service. Don't use comments when you enter a query.

If you don't have a query, you can use the following sample that queries for storage accounts:

resources
| where type == 'microsoft.storage/storageaccounts'

Power BI Desktop

After Power BI Desktop is installed, you can connect Azure Resource Graph with Power BI connector so that you can run a query.

The following example runs a query with the default settings.

1. Open the Power BI Desktop app on your computer and close any dialog boxes that are displayed.

2. Select Home > Options and settings > Data source settings.

3. Go to Home > Get data > More > Azure > Azure Resource Graph and select Connect.

   

4. On the Azure Resource Graph dialog box, enter your query into the Query box.

   

5. Select OK. If prompted, enter your credentials and select Connect to run the query.

6. Select Load or Transform Data.

   • Load imports the query results into Power BI Desktop.
   • Transform Data opens the Power Query Editor with your query results.

Power BI service

You need a workspace with Dataflow so you can connect Azure Resource Graph with Power BI connector and run a query.

1. Go to your organization's Power BI service.

2. Open a workspace and select New > Dataflow.

3. Select Add new tables from Define new tables.

4. In Choose data source type azure resource graph to search for the connector.

   

5. Select Azure Resource Graph.

6. Enter a query into the Query box. You can copy and paste the query.

   

7. Select Sign in to authenticate with your Organizational account.

8. Select Next to run the query.

The results are displayed in Power Query. You can select to save or cancel.

Use optional settings

You can select optional values to change the Azure subscription or management group that the query runs against or to get query results of more than 1,000 records.

Option	Description
Scope	You can select subscription or management group. Tenant is the default scope when no selection is made.
Subscription ID	Required if you select subscription scope. Specify the Azure subscription ID. Use a comma-separated list to query multiple subscriptions.
Management group ID	Required if you select management group scope. Specify the Azure management group ID. Use a comma-separated list to query multiple management groups.
Advanced options	To get more than 1,000 records change $resultTruncated to FALSE. By default Azure Resource Graph returns a maximum of 1,000 records.

For example, to run a query for a subscription that returns more than 1,000 records:

• Set the scope to subscription.
• Enter a subscription ID.
• Set $resultTruncated to FALSE.

Power BI Desktop

Power BI service

Clean up resources

When you're finished, close any Power BI Desktop or Power Query windows and save or discard your queries.

Next steps

For more information about the query language or how to explore resources, go to the following articles.

• Power BI connector troubleshooting guide.
• Understanding the Azure Resource Graph query language.
• Explore your Azure resources with Resource Graph.
• Sample queries listed by table or category.