An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
Hello Jignesh Desai
The "Dashboards with Grafana" feature embedded within Application Insights is a lightweight, built-in Grafana experience in the Azure portal. By design, it only supports Azure-native data sources specifically Azure Monitor and Azure Managed Prometheus.
This means Microsoft SQL Server cannot be added as a data source in the embedded "Dashboards with Grafana" experience. That's why you're unable to find the option to create a SQL Server data source there.
Reference: https://learn.microsoft.com/en-us/azure/azure-monitor/app/grafana-dashboards
To bring SQL Server data into a Grafana dashboard, you need to use Azure Managed Grafana with the Standard service tier. The Standard tier supports Microsoft SQL Server (MSSQL) as a built-in core Grafana data source.
Steps to Add SQL Server Data Source in Azure Managed Grafana:
- Create an Azure Managed Grafana workspace (Standard tier) from the Azure portal if you don't have one already.
- Open your Grafana workspace and go to Overview > Endpoint to launch the Grafana UI.
- In the Grafana UI, navigate to Connections > Data sources > Add new data source.
- Search for and select Microsoft SQL Server.
- Fill in the connection details:
- Host - IP address or hostname (and optional port, default is 1433) of your SQL Server instance.
- Database - Name of the database to connect to.
- Authentication - Choose between SQL Server authentication (username/password), Windows/Kerberos, or Azure Entra ID (managed identity or app registration).
- Click Save & Test to verify the connection.
Note: Grafana must have network access to your SQL Server instance (default port 1433). If your SQL Server is in a private network, you may need to configure Private data source connect or adjust firewall/NSG rules accordingly.
Reference: https://grafana.com/docs/grafana/latest/datasources/mssql/configure/
So, the embedded "Dashboards with Grafana" in Application Insights is limited to Azure data sources only. To use SQL Server as a data source, you would need to set up an Azure Managed Grafana workspace on the Standard tier, where Microsoft SQL Server is available as a built-in data source.
Thanks,
Suchitra.