Edit

Share via


Troubleshoot Azure Resource Graph Power BI connector

The following descriptions help you troubleshoot Azure Resource Graph (ARG) data connector in Power BI.

Connector availability

The ARG Power BI connector isn't available in all Power BI products and versions.

Version Products
2.123.x
(November 2023) or later
Power BI Datasets (Desktop + Service)
Power BI (Dataflows)
Fabric (Dataflow Gen2)

ARG Power BI connector isn't available in the following products:

  • Excel
  • Power Apps (Dataflows)
  • Dynamic 365 Customer Insights
  • Analysis Services

Supported capabilities

The ARG Power BI connector only supports import connections. The ARG Power BI connector doesn't support DirectQuery connections. For more information about connectivity modes and their differences, go to DirectQuery in Power BI.

Load times

The load time for ARG queries in Power BI is contingent on the query response size. Larger query results might lead to extended load times.

Unexpected Results

If your query yields unexpected or inaccurate results, consider the following scenarios:

  • Verify permissions: Confirm that your Azure role-based access control (Azure RBAC) permissions are accurate, as the results of the queries are subject to Azure RBAC. Ensure you have at least read access to the resources you want to query. Queries don't return results without adequate permissions to the Azure object or object group.
  • Check for comments: Review your query and remove any comments (//) because Power BI doesn't support Kusto comments.
  • Compare results: For parity checks, run your query in both the ARG Explorer in Azure portal and the ARG Power BI connector. Compare the results obtained from both platforms for consistency.

Errors

The ARG connector's query capability behaves the same at ARG Explorer in the Azure portal. For information about ARG common errors, go to the troubleshooting guide.

For Power BI errors, go to common issues.

The following table contains descriptions of common ARG Power BI connector errors.

Error Description
Invalid query Query that was entered isn't valid. Check the syntax of your query and refer to the ARG Kusto Query Language (KQL) for guidance.
Scope check If you're querying at the tenant scope, ensure the subscription ID and management group ID fields are empty.

If you have inputs in the subscriptions ID or management group ID fields that you want to filter for, select either subscription or management group from the drop-down scope field.
Scope subscription mismatch The subscription scope was selected from the scope drop-down field but a management group ID was entered.
Scope management group mismatch The management group scope was selected from the scope drop-down field but a subscription ID was entered.