This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 15%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Hello, I am trying to run an az cli command to get the total cost of all the resources which has tag and when i run the below script i am getting the following error. can someone help me in fix this.
$billingScope = "subscriptions/xxxx"
az costmanagement query --type "Usage" --dataset-aggregation '{\"totalCost\":{\"name\":\"PreTaxCost\",\"function\":\"Sum\"}}'
--dataset-grouping name="ResourceId" type="Dimension" --timeframe "MonthToDate" --scope "$billingScope" `
--dataset-filter '{\"tag\":{\"name\":\"Environment\",\"operator\":\"In\",\"values\":[\"UAT\",\"Prod\"]}}'
Error Message :
az : ERROR: (BadRequest) Invalid query definition: Invalid dataset filter; on a QueryFilter one and only one of and/or/not/dimension/tag can be set.
At line:2 char:1
(Request ID: ff49a644-1bf6-4806-b28c-e8232fd40a80)
Code: BadRequest
Message: Invalid query definition: Invalid dataset filter; on a QueryFilter one and only one of and/or/not/dimension/tag can be set.
(Request ID: ff49a644-1bf6-4806-b28c-e8232fd40a80)
@Admin (KK) Thank you for your post and I apologize for the delayed response!
The error in your original post specifies that you have missing dimension in your query filter. Could you replace this
filter '{\"tag\":{\"name\":\"Environment\",\"operator\":\"In\",\"values\":[\"UAT\",\"Prod\"]}}' with
filter '{\"dimensions\":{\"name\":\"tag\",\"operator\":\"In\",\"values\":[\"UAT\",\"Prod\"]}}' and give it a try?
Let us know how it goes!
Thanks, could you also send me the powershell command let version of the above query.
$billingScope = "subscriptions/xxxx"
az costmanagement query --type "Usage" --dataset-aggregation '{\"totalCost\":{\"name\":\"PreTaxCost\",\"function\":\"Sum\"}}'
--dataset-grouping name="ResourceId" type="Dimension" --timeframe "MonthToDate" --scope "$billingScope" `
--dataset-filter '{\"dimensions\":{\"name\":\"frequency\",\"Operator\":\"In\",\"Values\":[\"daily\"]}}'
Same Issue
z : ERROR: (BadRequest) Invalid query definition: Invalid dataset filter; on a QueryFilter one and only one of and/or/not/dimension/tag can be set.
At line:2 char:1
(Request ID: bdb92913-a3f5-4374-971d-e25b974aa373)
Code: BadRequest
Message: Invalid query definition: Invalid dataset filter; on a QueryFilter one and only one of and/or/not/dimension/tag can be set.
(Request ID: bdb92913-a3f5-4374-971d-e25b974aa373
@Admin (KK) I have updated your query to use a different dimension filter. Could you give this a shot to see if this works? You will need to replace actual Resource group name of the Azure resource to test this out.
$billingScope = "subscriptions/xxxx"
az costmanagement query --type "Usage" \--dataset-aggregation '{\"totalCost\":{\"name\":\"PreTaxCost\",\"function\":\"Sum\"}}'
--dataset-grouping name="ResourceId" type="Dimension" --timeframe "MonthToDate" --scope "$billingScope" --dataset-filter '{\"dimensions\":{\"name\":\"ResourceGroup\",\"Operator\":\"In\",\"Values\":[\"Enter ResourceGroupName \"]}}'
@Admin (KK) You would need to use Usage Details, pull the data to your side and filter the data to what you need.