Open live Kusto query in Excel

Published Feb 22 2022 04:21 AM 1,875 Views
Microsoft

Sharing is the easiest way to give people access to your ADX queries and queries results, and we already support several ways in which you can share those with others. 

Today we are excited to announce the ability to open a live query in an Excel Workbook, so that it can be refreshed directly from Excel.

Using Open in Excel new feature, you can now provide access to live results of your query by sharing the connected Excel Workbook with colleagues and team members.     

 

Using Open in Excel in ADX web explorer

To create an Excel Workbook connected to ADX, start by creating a query in ADX web explorer.
Once you have a result set you are happy with, click the 'Open In Excel' button, located under the 'Share' menu :

Michal_Bar_0-1645531736043.png

ADX web explorer will create and download an Excel workbook that is connected to ADX.

Open the downloaded file and continue in Excel.

 

Excel integration

Depending on your Excel settings, you may need to click enable editing in Excel to allow the file to update.

Michal_Bar_0-1645533171929.png

 

Additionally, depending on your settings you may need to allow Excel to access external data connections.

Michal_Bar_1-1645533220785.png

Note: when using the 'Open In Excel' feature for the first time, you may be prompted to authenticate with Azure Data Explorer. 

 

The Excel workbook that was just created is connected to ADX and is refreshable.

This means that whenever you want, you can refresh your Excel workbook with new data from ADX and all related Excel artifacts, like charts and pivot tables may be refreshed based on the new data.

 

This new integration between ADX and Excel is yet another way to help you be more productive using different Microsoft tools, and specifically using Azure data and the Office suite.

 

ADX web explorer team is looking forward for your feedback in KustoWebExpFeedback@service.microsoft.com

You’re also welcome to suggest more ideas and vote for them here - https://aka.ms/adx.ideas

%3CLINGO-SUB%20id%3D%22lingo-sub-3198500%22%20slang%3D%22en-US%22%3EOpen%20live%20Kusto%20query%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3198500%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3ESharing%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eis%20the%20easiest%20way%20to%20give%20people%20access%20to%20your%20ADX%20queries%20and%20queries%20results%2C%20and%20we%20already%20support%20several%20ways%20in%20which%20you%20can%20share%20those%20with%20others.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EToday%20we%20are%20excited%20to%20announce%20the%20ability%20to%20open%20a%20live%20query%20in%20an%20Excel%20Workbook%2C%20so%20that%20it%20can%20be%20refreshed%20directly%20from%20Excel.%3C%2FP%3E%0A%3CP%3EUsing%20%3CEM%3EOpen%20in%20Excel%3C%2FEM%3E%20new%20feature%2C%20you%20can%20now%20provide%20access%20to%20live%20results%20of%20your%20query%20by%20sharing%20the%20connected%20Excel%20Workbook%20with%20colleagues%20and%20team%20members.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSTRONG%3EUsing%20Open%20in%20Excel%20in%20ADX%20web%20explorer%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3ETo%20create%20an%20Excel%20Workbook%20connected%20to%20ADX%2C%20start%20by%20creating%20a%20query%20in%20ADX%20web%20explorer.%3CBR%20%2F%3EOnce%20you%20have%20a%20result%20set%20you%20are%20happy%20with%2C%20click%20the%20'Open%20In%20Excel'%20button%2C%20located%20under%20the%20'Share'%20menu%20%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Michal_Bar_0-1645531736043.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350324i9C64A9015245E77D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Michal_Bar_0-1645531736043.png%22%20alt%3D%22Michal_Bar_0-1645531736043.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EADX%20web%20explorer%20will%20create%20and%20download%20an%20Excel%20workbook%20that%20is%20connected%20to%20ADX.%3C%2FP%3E%0A%3CP%3EOpen%20the%20downloaded%20file%20and%20continue%20in%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSTRONG%3EExcel%20integration%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3EDepending%20on%20your%20Excel%20settings%2C%20you%20may%20need%20to%20click%20enable%20editing%20in%20Excel%20to%20allow%20the%20file%20to%20update.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Michal_Bar_0-1645533171929.png%22%20style%3D%22width%3A%20573px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350328iEC83A9A9F5D1E5B2%2Fimage-dimensions%2F573x176%3Fv%3Dv2%22%20width%3D%22573%22%20height%3D%22176%22%20role%3D%22button%22%20title%3D%22Michal_Bar_0-1645533171929.png%22%20alt%3D%22Michal_Bar_0-1645533171929.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EAdditionally%2C%20depending%20on%20your%20settings%20you%20may%20need%20to%20allow%20Excel%20to%20access%20external%20data%20connections.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Michal_Bar_1-1645533220785.png%22%20style%3D%22width%3A%20441px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350329iB95FAEBB69BE5B06%2Fimage-dimensions%2F441x211%3Fv%3Dv2%22%20width%3D%22441%22%20height%3D%22211%22%20role%3D%22button%22%20title%3D%22Michal_Bar_1-1645533220785.png%22%20alt%3D%22Michal_Bar_1-1645533220785.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bwhen%20using%20the%20'Open%20In%20Excel'%20feature%20for%20the%20first%20time%2C%20you%20may%20be%20prompted%20to%20authenticate%20with%20Azure%20Data%20Explorer.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Excel%20workbook%20that%20was%20just%20created%20is%20connected%20to%20ADX%20and%20is%20refreshable.%3C%2FP%3E%0A%3CP%3EThis%20means%20that%20whenever%20you%20want%2C%20you%20can%20refresh%20your%20Excel%20workbook%20with%20new%20data%20from%20ADX%20and%20all%20related%20Excel%20artifacts%2C%20like%20charts%20and%20pivot%20tables%20may%20be%20refreshed%20based%20on%20the%20new%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThis%20new%20integration%20between%20ADX%20and%20Excel%20is%20yet%20another%20way%20to%20help%20you%20be%20more%20productive%20using%20different%20Microsoft%20tools%2C%20and%20specifically%20using%20Azure%20data%20and%20the%20Office%20suite.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EADX%20web%20explorer%20team%20is%20looking%20forward%20for%20your%20feedback%20in%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22mailto%3AKustoWebExpFeedback%40service.microsoft.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EKustoWebExpFeedback%40service.microsoft.com%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EYou%E2%80%99re%20also%20welcome%20to%20suggest%20more%20ideas%20and%20vote%20for%20them%20here%20-%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faka.ms%252Fadx.ideas%26amp%3Bdata%3D04%257C01%257Cgabil%2540microsoft.com%257C43f767ad65614ab696ef08d99f87d3df%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637716228566429665%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3D%252FQDVmU03PGyyBRbK6voUtSQ7wxwaQjQs%252B45IZDFqMCI%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fadx.ideas%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3198500%22%20slang%3D%22en-US%22%3E%3CP%3ENew%20feature%20in%20ADX%20web%20explorer%20allows%20you%20to%20open%20a%20live%20query%20in%20an%20Excel%20Workbook%20so%20that%20you%20can%20refresh%20it%20from%20Excel.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3198500%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EADX%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Data%20Explorer%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EKQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EKusto%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Feb 22 2022 05:46 AM
Updated by: