In Azure Monitor metrics, you are required to provide time grain in ISO 8601 format. So when you provide the value from a template variable of type “Interval”, the query fails giving a similar error message:
request failed, status: 400 Bad Request, body: {"code":"BadRequest","message":"Detected invalid time grain input: 6h, Iso 8601 duration format sample (PT1H, P1DT32M22S, etc.,), Do not support week: P2W"}
It would be so beneficial if you can support this mapping from Interval variables to ISO 8601 format in Azure Monitor datasource.
Thanks!