Azure Data Explorer

Kusto Exception while publishing telemetry

Hello team, We are getting the below exception while publishing telemetry via API, can you please let us know the root cause, this is happening intermittently . Exception Details Kusto client failed to send a request to the service: 'Connection timed…

Error (3803) “Linked service type not supported by DataScan” while scanning on-prem PostgreSQL in Azure Purview using SHIR

Hi , I am trying to integrate an on-premises PostgreSQL server (installed on a separate VM) with Azure Purview using a Self-Hosted Integration Runtime (SHIR). I have: Installed and configured SHIR successfully Created the PostgreSQL data source in…

Azure Data explorer database partitioning

Hi, I'm trying to have a database with 1 big table, partitioned by a column string called UNIT_NUMBER. However, when I change the partition policy, I don't see the partitions and the queries' memory and execution time is higher than expected. Is there…

ADX Ingestion parquet error

Screenshot 2026-01-27 at 11.01.13 AM.png When copying Parquet data from Azure Storage to Azure Data Explorer (ADX) and experiencing row count differences or data discrepancies, it is usually due to schema mismatches, unsupported nested data structures,…

Trying creating a data connection but keeps getting internal server error

Getting internal server error when trying to create a data connection to Event Grid. Service name: mingjitestadx "statusMessage":…

Understand Azure Data Explorer materialized view refresh rate

I have a materialized view in ADX created with this query: .create-or-alter materialized-view LatestSimpleMeasurements on table SimpleMeasurements { SimpleMeasurements | summarize arg_max(timestamp,*) by sensorId, dataPointId } it is as simple as, get…

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…