Connect Az managed Grafana instance to Azure Data Explorer cluster

Saikrishnan Srivatsan 0 Reputation points Microsoft Employee
2024-03-19T05:08:29.99+00:00

I have an Azure Data Explorer cluster that's stood up in tenant A. I am trying to connect to it from my Grafana UI(adding a new data source), which is in tenant B. In the Azure Data Explorer cluster DB, I have added the necessary permissions using the app id and tenant id using. Now I see my app in the listed in the ADE permissions screen with "Viewer" access.

.add database Grafana viewers ('aadapp=
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
525 questions
Azure Managed Grafana
Azure Managed Grafana
An Azure service used to deploy Grafana dashboards for analytics and monitoring solutions.
104 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Azar 22,860 Reputation points MVP
    2024-03-19T06:16:55.5666667+00:00

    Hey there Saikrishnan Srivatsan

    Thats a good question and thanks for using QandA platform.

    Deployments can sometimes take longer than expected, especially in complex environments . However, if your deployment has been running for an unusually long time (e.g., more than a few hours**). I recommend checking the deployment logs for any errors or warnings that could provide insights into the delay.** Additionally, you can monitor the deployment progress in the Azure portal to see if it's making any progress or if it's stuck at a particular stage.

    The inability to delete VNets and subnets due to "serviceAssociationLinks" typically means that there are resources still associated with them, such as network interfaces, virtual machines, or other Azure services. Before deleting a VNet or subnet, you need to remove all associated resources to ensure a clean deletion.Once all associated resources are removed, you should be able to delete the VNet/subnet without any issues.

    If this persists i recommend reaching out to Azure support for further assistance. link below

    https://learn.microsoft.com/en-us/managed-desktop/operate/support-request

    If this helps kindly accept the answer


  2. ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee
    2024-03-21T09:13:28.4133333+00:00

    Hi Saikrishnan Srivatsan,

    It seems like you are trying to connect to an Azure Data Explorer cluster from your Grafana UI, but you are facing some issues. To connect to an Azure Data Explorer cluster from Grafana, you need to set up authentication for Azure Data Explorer through Azure Active Directory (Azure AD).

    Since you have already added the necessary permissions using the app id and tenant id, you can follow the below steps to configure the data source for Azure Managed Grafana:

    1. Open your Grafana endpoint and go to Configurations > Data Sources > Azure Data Explorer.
    2. Check if the information listed for Azure cloud, Cluster URL, Directory (tenant) ID, Application (client) ID, and Client secret is correct. If needed, create a new key to add as a client secret.
    3. At the top of the page, you can find instructions guiding you through the process to grant necessary permissions to this Azure AD app to read the Azure Data Explorer database.
    4. Make sure that your Azure Data Explorer instance doesn't have a firewall that blocks access to Managed Grafana. The Azure Data Explorer database needs to be exposed to the public internet.

    If you have followed these steps and still facing issues, please provide more information about the error message you are receiving so that I can assist you better.


Your answer

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