How can you access ADX (aka Kusto) data in from Excel?
Using Power Query (Known in Excel as Get & Transform), you can connect to Kusto and import data into Excel.
Data can be imported into the data model or into a table or a pivot cache.
In any case the keyword is import, which means that to see new data, you need to refresh and wait for all the data to be imported again. Typically, data in Kusto is counted in Billions of rows and cannot be brought fully into Excel memory.
In many cases you also want to see fresh data as soon as it arrives to Kusto.