Steps to reproduce:

1. Add Host - Hostname Azure SQL Managed Instance (Not Azure SQL) xxxxx.xxxxx.database.windows.net
2. Add Template "Template DB MSSQL by ODBC Template DB MSSQL by ODBC"
3. Set Macros {$MSSQL.DSN}, {$MSSQL.USER}, {$MSSQL.PASSWORD}, {$MSSQL.PORT}
4. Install MS ODBC driver from Microsoft repository
5. Confirm odbcinst.ini entry for [ODBC Driver 17 for SQL Server] --> add Same entry as [mssql]:
6. [mssql]
   Description=Microsoft ODBC Driver 17 for SQL Server
   Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1
   UsageCount=1
7. Add odbc.ini entry with SQL Managed Instance server name:
8. sql###########xxxxxtest
   Description = MSSQL MI databases
   Driver = mssql
   server = xxx######xxx###.xxxxxxxxxxxx.database.windows.net
   User = xxxxxx
   Password = xxxxxx
   Port = 1433
   Database = sql###########xxxxxtest

Result:

The Only key that works are:

mssql.db.state

db.odbc.get

mssql.uptime

mssql.version

net.tcp.service

Running Template Query "Get Performance Counters" 

gives AU Cleanup Values, but no Instance_name

Query returns 5528 rows. attached is CSV of the result of that query.

Zabbix_server.log is same error message as image

Expected:

data is should be collected.

Please let me know if there is anything else I can try. I suspect it could be the Different version or Azure SQL Managed Instance (Ref: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview)