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.
589 questions
0 answers
Azure Data Explorer: Working with aggregation materialized views and historical data
HI We have the following scenario SourceTable => Deduplication Materialized View => Multiple Aggregation Materialized views based on the deduplicated view (Daily, Weekly, Monthly) In the source table we can backfill historical data with…
Azure Data Explorer
![](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
.alter column policy encoding for larger than BigObject32 provision
Hi https://learn.microsoft.com/en-us/kusto/management/alter-encoding-policy?view=microsoft-fabric Per above documentation, the largest object that can be held in a column is 32MB. How do we deal with objects larger than 32MB, for example - to process an…
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.
589 questions
asked 2025-08-17T20:59:53.71+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-20T07:33:31.43+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,815
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Star schema with multiple fact tables
How would you structure your data if we have two fact tables. As an example, let's say I have an Accounts table as a dimension table, so only a single row for each account. Then I have an Orders table which could have multiple orders per Account. And 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.
589 questions
asked 2024-10-26T16:55:16.31+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(153.6, 49%, 24%)' 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)
Carnabuci, Michael P
40
Reputation points
edited the question 2025-08-13T08:55:50.4466667+00:00
Gérard Oomens
105.8K
Reputation points
Volunteer Moderator
0 answers
Difficulty accessing web form to contact either the MS Privacy Team or the Data Protection Officer
Hello. I've been trying repeatedly to access the web form to submit a Data Subject Access Request (DSAR) via the Data Protection Officer at the following link provided: https://aka.ms/privacyresponsemsa However, each time I'm directed to sign in and then…
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.
589 questions
asked 2025-08-12T11:52:20.1466667+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(0, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN6%3C/text%3E%3C/svg%3E)
NotTodaySatan-667
0
Reputation points
edited the question 2025-08-12T13:00:58.1266667+00:00
Gérard Oomens
105.8K
Reputation points
Volunteer Moderator
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
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.
589 questions
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
29,415
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.
589 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.
589 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.
589 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
739 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.
589 questions
asked 2025-07-31T21:06:01.9133333+00:00
databricksuser-5173
20
Reputation points
commented 2025-08-01T16:38:49.75+00:00
Venkat Reddy Navari
5,815
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.
589 questions
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.
589 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
29,415
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.
589 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.
589 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.
589 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.
589 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,430
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.
589 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,430
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.
589 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.
589 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,230
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.
589 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.
589 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,430
Reputation points Microsoft External Staff
Moderator