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.
585 questions
1 answer
How to use existing cache for external table when acceleration in progress
I enabled query acceleration for my external table which binds a delta table (1TB) on ADLS. But acceleration progress needs 1.5 hours to complete. I found during acceleration in progress, querying on the table is quite slower than case when acceleration…
Azure Data Explorer
asked 2025-07-31T06:22:57.8233333+00:00
Kunpeng Fan
0
Reputation points Microsoft Employee
commented 2025-08-07T14:05:52.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
28,310
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
The time series visualisation for queries in data explorer shows blank when I choose the multiple panels option
Following the examples in (https://learn.microsoft.com/en-us/kusto/query/anomaly-detection?view=microsoft-fabric) I'm trying to visualize a decomposition of a time series in Azure Data Explorer. However, when I choose the y-split option, the y-panels…
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.
585 questions
asked 2025-07-31T08:41:44.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 67%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cedric Mélange
20
Reputation points
accepted 2025-08-06T15:22:45.9466667+00:00
Cedric Mélange
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Need access to Kusto cluster DB - https://azure***&&&**.kusto.windows.net
We are trying to get access to [ https://azure***&&&**.kusto.windows.net ] kusto cluster DB to view the telemetry details and also finding the latest details who access the resource for all the subscription under Azure Storage service, need…
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.
585 questions
asked 2025-08-05T12:23:15.84+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 35%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Pavan Kumar Varma Nadimpilli (MINDTREE LIMITED)
20
Reputation points Microsoft External Staff
accepted 2025-08-06T11:17:20.8366667+00:00
Pavan Kumar Varma Nadimpilli (MINDTREE LIMITED)
20
Reputation points Microsoft External Staff
2 answers
MULTIJSON data format missing when creating a Data Explorer data connection in the Azure Portal
When creating a data connection from ADX/Kusto to EventHub, I would like to choose the MULTIJSON data format. If I recall correctly, this option was available in the Azure Portal, but there is only the JSON format now (see screenshot). The docs still…
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.
585 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
735 questions
asked 2023-11-01T20:42:29.5433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2025-08-01T19:13:35.1833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 13%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Morais, Nelson
5
Reputation points
1 answer
Azure Data Explorer Kusto Sort Order make_set guaranteed order of input
Hi, https://learn.microsoft.com/en-us/kusto/query/make-set-aggregation-function?view=microsoft-fabric Above link says "The array's sort order is undefined". Is there a way to construct the array guaranteeing preserving the order of input…
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.
585 questions
asked 2025-07-31T21:06:01.9133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 11%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED5%3C/text%3E%3C/svg%3E)
databricksuser-5173
20
Reputation points
commented 2025-08-01T16:38:49.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 50%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Venkat Reddy Navari
5,330
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Wrong extent dates in ADX deduplicated materialized view
Hi I'm having the following scenario. We have a Source Table (which can include duplicate records) We have a materialized view which deduplicates with the following command: .create materialized-view with (lookback=1d,…
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.
585 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 37%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E0%3C/text%3E%3C/svg%3E)
1 answer
Not able to run Kusto Explorer on my Local Machine
Kusto Explorer is not running on my local machine. Snippet of the Log file. COMPONENT STORE TRANSACTION FAILURE SUMMARY * Transaction at [17-07-2025 14:27:03] - Staging of a component (GJODRCJV.HAW.application) did not succeed. - Setting one or…
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.
585 questions
asked 2025-07-17T09:04:52.9633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 79%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rajarshi Sarkar
0
Reputation points Microsoft Employee
commented 2025-07-22T19:17:24.62+00:00
Smaran Thoomu
28,310
Reputation points Microsoft External Staff
Moderator
2 answers
ADX cluster 1 zone
We currently have an Azure Data Explorer (ADX) cluster configured to run across Availability Zones 1, 2, and 3. The cluster is marked as Zonal, and under the cluster settings, it shows: Availability zones: 1, 2, 3 Zones status: Zonal Since this is a…
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.
585 questions
asked 2025-07-18T12:53:22.9866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 18%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sereena Kurunkadan
0
Reputation points
answered 2025-07-22T14:43:14.7933333+00:00
Sander van de Velde | MVP
36,941
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
How do custom lookback columns in Azure Data Explorer deduplication Materialized Views work?
I was wondering if anybody has experience using lookback columns within deduplication Materialized Views in Adx https://learn.microsoft.com/en-us/kusto/management/materialized-views/materialized-view-create?view=microsoft-fabric#lookback-column Let's…
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.
585 questions
1 answer
One of the answers was accepted by the question author.
Azure Data Explorer
Hello, I was looking for a way to connect Azure Data Explorer to storage account that has public access disabled, I noticed that Vnet Injection was deprecated in February. Is there any other way to connect securely to a storage account? Best…
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.
585 questions
asked 2025-06-30T15:20:31.4133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 89%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michel SFEIR
20
Reputation points
commented 2025-06-30T17:44:52.85+00:00
Michel SFEIR
20
Reputation points
1 answer
How do I download Database from Azure Data Explorer?
Hello, I'm trying to download my database to a hard drive as a backup, however I'm having a hard time downloading the Data Explorer database. I know I can download it by runnning a KQL script for each table, but I have 60+ tables, and don't want to have…
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.
585 questions
asked 2025-06-25T16:15:03.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 89%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nathan Sommer
40
Reputation points
commented 2025-06-27T16:57:00.81+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
15,425
Reputation points Microsoft External Staff
Moderator
1 answer
Azure Data Explorer Cluster
Hi there, I am having some issues with KQL in Azure Data Explorer Cluster, I have made sure that I have admin permissions to the Cluster and the database itself but when running KQL queries they just get stuck in Preparing to run, no matter how big or…
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.
585 questions
asked 2025-06-20T07:44:25.0933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 11%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Luis Loaysa Admin
0
Reputation points
commented 2025-06-26T16:52:12.99+00:00
Chandra Boorla
15,425
Reputation points Microsoft External Staff
Moderator
1 answer
Sharing Dashboards requires workaround
When sharing a link with coworkers on the same tenant, they always get denied due to authorization. I've given them all the permissions I have within the ADX resource, the database, and the dashboard. They are able to access the dashboard as expected BUT…
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.
585 questions
asked 2025-06-24T15:32:21.1566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 22%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Paul Roland
0
Reputation points
commented 2025-06-25T17:08:21.7633333+00:00
Paul Roland
0
Reputation points
1 answer
HCNS Service Dashboard Dashboard not working
Hello team, The HCNS Service Dashboard is not loading date for me although I do have the required membership on coreidentity Entitlements. https://dataexplorer.azure.com/dashboards/ Please guide me on how to fix this issue. Thanks, HoseinScreenshot…
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.
585 questions
asked 2025-06-23T16:40:04.41+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 57.99999999999999%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
Hosein Paydar
0
Reputation points Microsoft Employee
commented 2025-06-25T13:23:32.7733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Ganesh Gurram
7,305
Reputation points
Moderator
1 answer
One of the answers was accepted by the question author.
Unable to load file into table.
I'm not able to upload a local csv file into a table. I'm able to click Get Data, choose Local file, and upload the file, but after I click Next to go to the Ingest screen, it closes out of the window all together preventing me from ingesting the file. 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.
585 questions
asked 2025-06-20T18:26:50.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 38%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ashley Smith (Accenture Federal Services LLC)
45
Reputation points Microsoft External Staff
accepted 2025-06-23T17:31:42.5866667+00:00
Ashley Smith (Accenture Federal Services LLC)
45
Reputation points Microsoft External Staff
1 answer
Why does trim_end("bom", "dotcom.com") return the original string, while trim_end("com", "dotcom.com") trims as expected?
I'm working with trim_end() in KQL (Azure Data Explorer) and noticed some confusing behavior when using different combinations of characters to trim a domain string. Here’s a minimal repro: let ExampleTable = datatable(domain: 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.
585 questions
asked 2025-06-16T14:54:02.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 15%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kooghan Williams
0
Reputation points
commented 2025-06-18T18:05:14.7166667+00:00
Chandra Boorla
15,425
Reputation points Microsoft External Staff
Moderator
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.
585 questions
asked 2025-06-04T17:02:10.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 26%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Soujanya Maniyambakam Balakrishna
0
Reputation points
commented 2025-06-10T17:09:16.6833333+00:00
Chandra Boorla
15,425
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.
585 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 74%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
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.
585 questions
asked 2025-05-27T09:05:39.5266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 44%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Jatin Kolhe
0
Reputation points
commented 2025-06-05T10:34:29.2733333+00:00
Venkat Reddy Navari
5,330
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.
585 questions
asked 2025-05-31T09:09:29.85+00:00
databricksuser-5173
20
Reputation points
commented 2025-06-05T08:16:16.9+00:00
Anonymous