Azure Data Explorer

If I use student account in azure I can get discount. But it is not showing the discount when I scheduled an exam

Microsoft Azure:data fundamentals... I don't get discount when I use my student account. Kindly check my query and solve it as possible u can. And send me the reply how to solve this problem with detailed information …

External table with year partition fails to query data from previous year after calendar year change

Hi All, We have an external table in Azure Data Explorer pointing to Azure Blob Storage with partitioning by year and month. The table worked correctly until December 31, 2025, but stopped returning results on January 1, 2026, despite no changes to the…

My Azure Data Explorer dashboards are not accesible Error: Principal add user : Is not authorized, I have all security group access.

Hi I have recently joined the ACE project but I have given all the security group permissions, but till i was not able to access the Azure dash board and kusto dashboards getting error, attached in the screenshots. Please help me on this please.

Azure Data Explorer cluster stuck in Stopped state due to repeated version deployment failures

Hello, I've suddenly been confronted with an issue where our ADX cluster is currently in a Stopped state and fails to start. The Activity Log consistently shows “Cluster version deployment failed.” Attempts to start the cluster via portal and CLI result…

Which is faster and more reliable for searching JSON application logs: Azure Data Explorer (ADX) or Log Analytics Workspace?

Hi Team, I am trying to choose between Azure Data Explorer (ADX) and Azure Log Analytics Workspace for storing and searching application logs, and I need guidance on performance. My use case: Application logs are generated from VMs / services Logs are…

ADX cluster 5 minutes latency on streaming ingestion

The ADX cluster I'm running has an ingestion latency of 5 minutes since the 23rd of November. The cluster has streaming ingestion enabled on the cluster and tables, which has worked for more than a year. It's stuck specifically around the 5 minute mark…

ADX Ingestion parquet error

Good morning, starting from Sunday 07/12 morning, I'm experiencing an error in the ingestion of parquet file into adx, both manually or automatic using Event Hub. BadRequest_InvalidBlob: Failed in querying or exporting parquet files: PQV3:: LibErr:…

Data explorer spinning / unresponsive Edge

Yesterday was working fine until late morning. Any attempt to open Item or run a query against cosmos container spins for a very long time the first time, subsequent attempts return: "Error sending request: Failed to fetch" Another coworker…

How to fix 'parse' operator: Failed to resolve scalar expression named 'msg_s' If the issue persists, please open a support ticket. Request id: 117cf54a-1039-4496-b8b1-13730efa136e

ADX streaming ingestion failures for non-streaming tables

I have several ADX outputs from various Azure Stream Analytics (ASA) jobs. All the outputs are configured on tables in databases where the tables have streaming ingestion disabled and the ingestion batching policy is inherited from the database. However,…

Empty workspaces in Azure Data Explorer web portal

Hi, I am getting this odd experience on Azure Data Explorer web portal since this morning. I cannot see any of my dashboards, and none of the dashboard links that I bookmarked works. As soon as I open the dashbaord link (which worked completely earlier…

Deploying Azure Database Watcher via IaC fails intermittently

Hi there, I'm deploying the preview of Azure Database Watcher but I'm seeing some odd behaviour. When deploying the cluster, I receive the error below after deployments often. This is the bicep excerpt for the cluster deployment. I can't reproduce…

top 10 tables in Log Analytics Workspace

Hi All,   i want to see the top 10 tables using more space in the log analytics work space. need some help to fetch the top 10 tables can anyone please help me with query which can pull the top 10 tables using more space   appreciate for help in this. 

Encoding policy and materialized views

Hello ADX experts. What happens if the source table of a materialized view has an encoding policy set for one or more columns? Is the encoding policy preserved in the MV, or is it just ignored? I have the following staging table defined: .create table…

Table Level Security

I'm trying to grant access for certian groups based on tables. Right now everyone can see everything, only specific people need to see certain tables. How do I fix this? Thanks, Nathan

Is it possible to use an external table with an Azure SQL VM?

Hello, I am using an instance of SQL Server on an Azure VM, and I wanted to know if it is possible to use ADX External Tables. The VM does not have a public IP.

Most efficient way to take _n_ rows per group

Hello ADX experts. I have an ADX database with IoT sensor data. My use case is to retrieve a specified number of readings (rows) per MetricId after a certain date. The most natural way to do this seems to be using the partition by operator like…

Azure Data Explorer: LightIngest Managed Identity Authentication Issue

Hi all Hoping somebody could help me out here. We currently are trying to run LightIngest in a containerapp job in order to ingest massive amounts of data into adx, and do this with extra control mechanisms. however, the authentication via managed…

ADX performance issues

Hello , How to troubleshoot a ADX performance issues ? thanks Himanshu

Best practices for designing an ETL process for ingesting large volumes

How would you design an ETL process for ingesting large volumes of data from multiple sources into Azure Data Explorer? What are some best practices to keep in mind?