Share via

In Application Insights, under option 'Dashboard for Grafana', How to create sqlserver datasource?

Jignesh Desai 151 Reputation points
2026-04-21T06:40:12.2033333+00:00

Hi,

One Simple Question: In Application Insights, under option 'Dashboard for Grafana', I want to bring some data from sqlserver into Dashboard for Grafana, but I can't find a way to create SQL server data source. Any assistance please.

Regards

User's image

Azure Monitor
Azure Monitor

An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.


1 answer

Sort by: Most helpful
  1. Suchitra Suregaunkar 13,785 Reputation points Microsoft External Staff Moderator
    2026-04-21T07:52:18.3033333+00:00

    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.

    User's image 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.

    User's image 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:

    1. Create an Azure Managed Grafana workspace (Standard tier) from the Azure portal if you don't have one already.
    2. Open your Grafana workspace and go to Overview > Endpoint to launch the Grafana UI. User's image
    3. In the Grafana UI, navigate to Connections > Data sources > Add new data source.
    4. Search for and select Microsoft SQL Server. User's image
    5. 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).
    6. 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.

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.