cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure Data Explorer Blog
Options
700

Best practices in creating aggregations in Power BI and ADX

DanyHoter on Jun 26 2022 02:32 AM
Aggregations can be created in many ways: writing KQL, Group By in PQ, DAX measures What are the pros and cons of each m...
1,313

General availability: Azure Data Explorer connector for Power Automate, Logic Apps, and Power Apps

Tzvia Gitlin Troyna on Jun 19 2022 06:40 AM
Azure Data Explorer connector for Power Automate, Logic Apps, and Power Apps enables you to automate alerts and notifica...
4,094

When to use Azure Data Explorer

Tzvia Gitlin Troyna on Jun 12 2022 04:43 AM
Here, we'll discuss how you can decide whether Azure Data Explorer is the right choice for your big data analytics needs...
1,476

Azure Lv3 VM series delivers higher performance at a lower cost for Azure Data Explorer

Iris_Kaminer on Jun 09 2022 02:49 PM
Azure Data Explorer with Lasv3 and Lsv3 dramatically reduces the cost of observation analytics like telemetry, log and t...
882

An Approach to Unit Testing ADX Functions

David Giard on Jun 01 2022 08:33 AM
Automated Unit testing is an essential part of any application development life cycle. It validates that code works prop...
850

Welcome to your new Home page!

Michal_Bar on Jun 01 2022 03:24 AM
We are excited to launch a new Home page for ADX Web UI!
1,539

Azure Data Explorer in 60 minutes with the new samples gallery

minniw on Jun 01 2022 03:19 AM
With samples gallery, you can easily upskill and demo Azure Data Explorer leveraging sample datasets, tutorials(queries ...
976

Using the new amazing Power BI feature - Field Parameters

DanyHoter on May 31 2022 06:25 AM
In the May version of Power BI desktop, there is a new feature that is very significant - Field Parameters. Many writers...
913

Microsoft Defender for Cloud export to Azure Data Explorer

bwatts670 on May 26 2022 09:16 AM
How can I utilize Microsoft Defender for Cloud continuous export to send the data over to Azure Data Explorer? In this a...
1,149

ADX Web Explorer updates – May 2022

Michal_Bar on May 26 2022 12:23 AM
We are pleased to announce a new set of features across all areas of Azure Data Explorer Web UI
919

Implementing and Optimizing Bounding Box Queries in Azure Data Explorer

David Giard on May 25 2022 07:12 AM
In this article, I will show how to implement geographic bounding box queries using built-in functions, the limitations ...
1,143

Generating and Visualizing H3 Indexed Data with Kusto and Python

DrewFurgiuele on May 25 2022 05:45 AM
A practical example of how to use the power of Kusto's built-in H3 geospatial functions to analyze and present your data...
1,108

Optimized autoscale – predictive planning

Gabi Lehner on May 23 2022 03:18 AM
Predictive planning of autoscale brings the next level of performance and cost optimization of your ADX resources. It al...
1,001

Azure Schema Registry, Avro format, and ADX - short survey

Guy_Reginiano on May 02 2022 06:59 AM
Are you using Azure Schema Registry (part of Event Hub) and whish to integrate schema-less Avro to ADX? Help us improve ...
1,090

Use the one-click sample app generator to create code to ingest and query your data

Tzvia Gitlin Troyna on Apr 26 2022 11:22 PM
The one-click sample app generator is a tool that allows you to create a working app to connect to your Cluster & Databa...
926

M dynamic parameters are generally available in Power BI

DanyHoter on Apr 26 2022 04:38 AM
An unusual use of M dynamic parameters to push arbitrary values to a visual on a Power BI report
4,154

F1 telemetry analysis with Azure Data Explorer (ADX)

Anshul_Sharma on Apr 12 2022 09:54 PM
Formula 1 is one of the most fascinating data-driven sport – so competitive that even one tenth second of an advantage c...
1,365

Send data from Node-RED to free Azure Data Explorer (Kusto)

karasmus on Apr 12 2022 02:00 AM
With the new Node-RED to Kusto node, its now easy to send data directly from Node-RED to Azure Data Explorer
1,315

Merging ADX queries in Power BI

DanyHoter on Apr 10 2022 11:53 PM
Using merge in the right way, we can join multiple tables in Power BI and get the best performance. Only the right way i...
1,089

ARM Deploy Azure Data Explorer DB with Event Hub connection

vplauzon on Apr 05 2022 05:00 AM
We recently published an Azure Quick Template allowing you to deploy an Event Hub, an Azure Data Explorer cluster, datab...
2,072

Performance Optimizations for Applications using Azure Data Explorer

ashokanms on Apr 04 2022 11:26 PM
In many cases Azure Data Explorer’s inbuilt query capabilities can reduce the need to provision traditional memory cachi...
1,931

Multiple databases per data connection (Multi DB data connection)

Guy_Reginiano on Apr 04 2022 04:20 AM
Now, you can dynamically route data to an alternate database
1,142

Sampling the results of a query to be visualize in a line chart

DanyHoter on Apr 03 2022 10:25 AM
A line chart can plot a limited number of points. If we try to plot more, Power BI will sample the data. The article pro...
1,719

Exporting AWS CloudWatch Logs to Azure Data Explorer

DrewFurgiuele on Mar 31 2022 08:25 AM
If you're running AWS workloads and using CloudWatch, check out this real-world example of how you can ingest your logs ...
3,087

Azure Data Explorer: Zero Trust Security with Conditional Access

Anshul_Sharma on Mar 27 2022 07:12 PM
Azure Data Explorer launches support for Azure Active Directory Conditional Access.
1,886

ADX useful links

Guy_Reginiano on Mar 27 2022 05:03 PM
Want to learn more about ADX? Here are some useful links 
1,684

(Preview) Configure ADX table retention, caching and batching policies via one-click

Anshul_Sharma on Mar 21 2022 10:50 PM
Azure Data Explorer (ADX) now allows you to configure table retention, caching and batching policies via one-click Web i...
1,578

End to end Azure Data Explorer pipeline deployment with ARM

vplauzon on Mar 17 2022 06:00 AM
We can now deploy an Azure Data Explorer (ADX)-based solution end-2-end from a single ARM template, no storage account r...
1,817

Now in preview: Materialized Views Over Materialized Views

DrewFurgiuele on Mar 15 2022 11:57 AM
Let's take a look at how we can leverage a materialized view to first deduplicate our records, and then create another a...
1,723

New productivity features in Kusto Explorer

Michal_Bar on Mar 15 2022 02:49 AM
We are pleased to announce a few improvements to Kusto Explorer (Desktop version of Kusto Web Explorer) to help you be m...

Latest Comments

wernerzirkel
in How to increase query run-time limitation in Azure Data Explorer on Jun 27 2022 06:12 AM
Increasing individual query runtime may have impact on database performance. The more active users, the more focus on stability is required. Kusto is not different than any other db at this point. That is why I would consider introducing workload management. Here's an example:.alter cluster policy r...
0 Likes
shakthimaan
in How to increase query run-time limitation in Azure Data Explorer on Jun 26 2022 11:27 PM
In case of Kusto Explorer (not Web UI): Tools-->Options-->Connections
0 Likes
Dean Gross
in Azure Data Explorer in 60 minutes with the new samples gallery on Jun 13 2022 05:22 AM
Can we use this with Azure Purview? if so, how? If not, please provide something similar for Purview.
0 Likes
David Giard
in An Approach to Unit Testing ADX Functions on Jun 02 2022 09:37 AM
The code in this article is based on work done by the Microsoft Commercial Software Engineering team. Many of the original tests were written for a customer by Braden Eriksen.
0 Likes
YairoR
in ADX Web Explorer updates – May 2022 on May 26 2022 02:33 AM
Great updates!
0 Likes