Forum Discussion
Issue with azure resource graph query
I'm logged into powerBI and connected, I got perms within azure too. When I run this on azure query - it gives me all the virtual machines.
resources
where type == "microsoft.compute/virtualmachines"But when I run it powerBI I get - Details: "Please provide below info when asking for support: timestamp = 2024-06-21T13:00:47.9217043Z, correlationId = 70c68028-ee7c-46b9-93a3-c1ccbb0bf481. Details: There must be at least one subscription that is eligible to contain resources. Given: ''."
I am really unsure why, I gave it a subscription ID and it is logged into my azure.
Hi Anonymous ,
There must be at least one subscription that is eligible to contain resources. Given: ''." This problem generally occurs on the Azure side rather than Power BI.
Ensure that the subscription ID you're using in Power BI matches exactly with one of the subscriptions you have access to in Azure. Although you mentioned having permissions within Azure, it's worth re-verifying that your account has the necessary permissions to access the resources via Azure Resource Graph in both Azure and Power BI contexts. Specifically, ensure you have the 'Reader' role or higher on the subscription or resource group you're querying.
And here I find some links which maybe helpful:
Troubleshoot no eligible subscriptions in the Azure portal - Microsoft Cost Management | Microsoft Learn
There must be at least one subscription that is eligible to contain resources. · Issue #385 · Azure/aztfexport · GitHub
Response 400 : There must be at least one subscription that is eligible to contain resources. · Issue #475 · Azure/aztfexport · GitHub
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
There must be at least one subscription that is eligible to contain resources. Given: ''." This problem generally occurs on the Azure side rather than Power BI.
Ensure that the subscription ID you're using in Power BI matches exactly with one of the subscriptions you have access to in Azure. Although you mentioned having permissions within Azure, it's worth re-verifying that your account has the necessary permissions to access the resources via Azure Resource Graph in both Azure and Power BI contexts. Specifically, ensure you have the 'Reader' role or higher on the subscription or resource group you're querying.
And here I find some links which maybe helpful:
Troubleshoot no eligible subscriptions in the Azure portal - Microsoft Cost Management | Microsoft Learn
There must be at least one subscription that is eligible to contain resources. · Issue #385 · Azure/aztfexport · GitHub
Response 400 : There must be at least one subscription that is eligible to contain resources. · Issue #475 · Azure/aztfexport · GitHub
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.