570 questions with Azure Data Explorer tags

Sort by: Updated
Updated Created Answers
1 answer

Azure Data Explorer - Automating Dashboard Sharing with Multiple Users

Dear Community, I have multiple Azure Data Explorer dashboards that need to be shared with different users. The process for managing permissions is outlined well - Manage permissions, but adding around 50+ different users to each dashboard manually seems…

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.
570 questions
asked 2025-06-04T17:02:10.02+00:00
Soujanya Maniyambakam Balakrishna 0 Reputation points
commented 2025-06-10T17:09:16.6833333+00:00
Chandra Boorla 13,790 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

make-series operator not supported inside partition by, even though it should be

According to the documentation for the partition operator, i should be able to use the make-series operator within a subquery (https://learn.microsoft.com/en-us/kusto/query/partition-operator?view=azure-data-explorer). Yet, when I try to do that I get…

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.
570 questions
asked 2025-06-04T14:53:57.44+00:00
Kasper 20 Reputation points
accepted 2025-06-06T07:08:47.8833333+00:00
Kasper 20 Reputation points
1 answer

KQL Query output limit of 5 lakh rows

Hi , i have a kusto table which has more than 5 lakh rows and i want to pull that into power bi. When i run the kql query it gives error due to the 5 lakh row limit but when i use set notruncation before the query then i do not get this row limit error…

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.
570 questions
asked 2025-05-27T09:05:39.5266667+00:00
Jatin Kolhe 0 Reputation points
commented 2025-06-05T10:34:29.2733333+00:00
Venkat Reddy Navari 2,295 Reputation points Microsoft External Staff Moderator
1 answer

Azure Data Explorer - measures to improve concurrency, response time, throughput

Hi Reference: https://learn.microsoft.com/en-us/kusto/management/alter-merge-workload-group-command?view=microsoft-fabric As per recommendations in above link, increasing "MaxConcurrentRequests" has improved concurrency. Are there any other…

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.
570 questions
asked 2025-05-31T09:09:29.85+00:00
databricksuser-5173 20 Reputation points
commented 2025-06-05T08:16:16.9+00:00
J N S S Kasyap 3,300 Reputation points Microsoft External Staff Moderator
1 answer

Urgent Support: Lost KQL cluster connection after accidentally deleted the resource group

Our team lost our KQL cluster after I accidentally deleted the resource group associated with the cluster. Is there any way to recover this? It's super urgent and important. The Gaia does not work that it's not responding any message. Thank you.

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.
570 questions
asked 2025-06-03T00:59:12.5133333+00:00
Emily Qian 0 Reputation points Microsoft Employee
commented 2025-06-03T03:14:26.66+00:00
Emily Qian 0 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Azure Load Test to connect to ADX

Hi, Could you please recommend a working example to create Azure Load Test to connect to ADX using URL based approach and Managed System Identity authentication? thank you

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.
570 questions
asked 2025-05-21T21:25:31.3833333+00:00
databricksuser-5173 20 Reputation points
commented 2025-05-30T22:22:26.2966667+00:00
databricksuser-5173 20 Reputation points
1 answer One of the answers was accepted by the question author.

Unexpected Continuous Ingestion into Azure Data Explorer After Stopping Python Service

Hi, Today I encountered a strange issue with Azure Data Explorer (ADX) and would appreciate some guidance. Scenario: I created a Python function that receives data and ingests it directly into a table in ADX. Everything worked fine. Then, using NSSM, I…

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.
570 questions
asked 2025-05-12T18:31:39.4533333+00:00
Mohsen Akhavan 831 Reputation points
accepted 2025-05-24T05:25:20.27+00:00
Mohsen Akhavan 831 Reputation points
1 answer

How to List ResourceGroup Locks using Azure Resource Graph

I need an Azure Resource Graph query to list the resource group locks. I have tried AuthorizationResources and ResourceContainers tables, but they don’t seem to retrieve the resource group locks. Any help would be appreciated.

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.
570 questions
asked 2025-05-14T13:13:00.76+00:00
Siva Kalluri 0 Reputation points
edited the question 2025-05-21T15:00:20.6533333+00:00
SnehaAgrawal-MSFT 22,701 Reputation points Moderator
1 answer

How to identify the usage of Preview APIs of Azure Data Explorer /Kusto that will be retired?

My team received an email saying You're receiving this notification because you're associated with one or more Azure subscriptions that use an Azure Data Explorer (Microsoft.Kusto) API that is about to be retired. On 31 July 2025, we will be ending…

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.
570 questions
asked 2025-05-13T14:54:32.69+00:00
Eduardo Lira 0 Reputation points Microsoft Employee
answered 2025-05-13T18:11:14.2433333+00:00
Chandra Boorla 13,790 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Microsoft Sentinel where clause failing for more than one character

I'm having difficulty searching a field for a value in KQL. The field I am searching I get by decoding a base64 encoded string using the built in function base64_decode_tostring(). The string I am decoding is: …

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.
570 questions
Microsoft Sentinel
Microsoft Sentinel
A scalable, cloud-native solution for security information event management and security orchestration automated response. Previously known as Azure Sentinel.
1,287 questions
asked 2022-10-12T16:36:22.197+00:00
Liam Jones 146 Reputation points
accepted 2025-04-17T15:02:04.1666667+00:00
Liam Jones 146 Reputation points
1 answer

ADX Kusto Self Join with a combination of equality and inequality

Hi, How do we generate Kusto query to achieve a self-join query, where one column matches but the other doesn't? For example: myTable | where myColumnSubset == "mySubGroup" | join kind=inner ( myTable | where myColumnSubset ==…

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.
570 questions
asked 2025-04-14T23:00:47.3466667+00:00
databricksuser-5173 20 Reputation points
answered 2025-04-15T18:36:00.82+00:00
Ganesh Gurram 7,140 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

I would like to know if connector is available for SAP BPC?

Hi Experts, I am working on solution development to ingest data from different SAP systems to ADLS Gen 2. I have selected ADF for the integration and could see ADF connectors available for SAP BW, HANA, C2C etc. However, I don't find any information…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,558 questions
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.
570 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,582 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,697 questions
asked 2023-12-18T13:44:07.4133333+00:00
Sivaramakrishnan S 20 Reputation points
commented 2025-04-09T08:08:05.3266667+00:00
Gowtham Selvaraj 0 Reputation points
1 answer One of the answers was accepted by the question author.

How can I connect Azure Data Explorer to a Log Analytics resource using AMPLS to privately query

I have a log analytics workspace that is only accessible through AMPLS and Data Explorer doesnt appear to support connections to resources that are setup to only allow Restricted Private Inbound queries even when accessing via a device that has network…

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.
570 questions
asked 2025-04-07T16:02:41.57+00:00
James Shellis 20 Reputation points
accepted 2025-04-09T07:29:14.2666667+00:00
James Shellis 20 Reputation points
2 answers

Azure ADX - UpdatePolicy fails to insert data

Hi Everyone,   I believe everyone is doing good and safe.   I am facing challenge with ADX. Please find the problem details below.   Problem statement: We are unable to insert a result data into a target table from source table using an UpdatePolicy.  …

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.
570 questions
asked 2025-04-01T07:02:05.7166667+00:00
Krishna Kumar, Sai Hariharan 5 Reputation points
commented 2025-04-08T11:46:41.9033333+00:00
Anonymous
0 answers

E_RUNAWAY_QUERY

Hi, How do we systematically Debug and pinpoint the root cause of E_RUNAWAY_QUERY error? Are there any built in tools in ADX? .show queryplan is not useful. Typical errors read "Query Limits Exceeded...Partial Query Error.....Aggregated String…

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.
570 questions
asked 2025-03-31T23:41:58.65+00:00
databricksuser-5173 20 Reputation points
edited a comment 2025-04-07T10:55:21.35+00:00
Dileep Raj Narayan Thumula 255 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How do I recover data deleted from a table ?

How do I recover data deleted from a table ? The data has been automatically deleted by a data retention policy.

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.
570 questions
asked 2025-04-02T08:33:48.45+00:00
BIHI Tarik 20 Reputation points
accepted 2025-04-05T09:06:35.2066667+00:00
BIHI Tarik 20 Reputation points
2 answers

Inability in connecting to Azure Data Explorer cluster from WebUI

I created a ADE cluster through the Azure portal under my team's subscription. While the cluster looks active + has a URI link available, when I try to 1) click on the URI link or 2) add a connection from the WebUI, I get this error: Failed to connect…

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.
570 questions
asked 2025-03-31T21:40:39.32+00:00
Annie Zhou 40 Reputation points Microsoft Employee
commented 2025-04-03T06:37:46.71+00:00
phemanth 15,755 Reputation points Microsoft External Staff Moderator
1 answer

IsObject() isArray()

Hi, is there any IsArray() or IsObject() or IsBag() or typeof() function supported by Azure Data Explorer to check whether my Dynamic data is property bag or array, before applying mv-expand? My source sends semi-structured data to my application.…

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.
570 questions
asked 2025-03-30T01:29:27.4266667+00:00
databricksuser-5173 20 Reputation points
commented 2025-04-02T11:29:41.4433333+00:00
Anonymous
3 answers

Do I pay only for the storage in case that the Azure Data Explorer is stopped?

Hi all, In case that I have a stopped Azure Data Explorer cluster , do I pay only for the storage that I used. Kind regards, SM

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.
570 questions
asked 2023-09-26T18:30:57.4866667+00:00
SalvM 0 Reputation points
commented 2025-04-01T15:58:35.6466667+00:00
Sander van de Velde | MVP 36,526 Reputation points MVP Volunteer Moderator
1 answer

Datamodel graphic in context of PurView / Data Catalog

I govern conceptional, logical and physical models in Azure Data Catalog / PurView. How can I get an grahical overview of a selection of related entities? Is there a tool available providing some functionality to arrange entities and relationsships? …

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.
570 questions
Azure Data Catalog
Azure Data Catalog
An Azure service that serves as a system of registration and system of discovery for enterprise data assets.
110 questions
Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,613 questions
asked 2022-02-01T14:35:48.18+00:00
Heijo Hewel 21 Reputation points
commented 2025-03-31T12:09:32.2766667+00:00
GabrielTanase-9830 1 Reputation point