Visualize data using an Azure Data Explorer Kusto query imported into Microsoft Excel

  • Article

Azure Data Explorer provides two options for connecting to data in Excel: use the native connector or import a query from Azure Data Explorer. This article shows you how to import a query from Azure Data Explorer to Excel to visualize data. Add Kusto query as an Excel data source to do additional calculations or visualizations on the data.

Prerequisites

  • A Microsoft account or a Microsoft Entra user identity to sign in to the help cluster.

Define Kusto query as an Excel data source

  1. In Azure Data Explorer web UI, run the query and check the results.

  2. Select the Share tab and select Query to Power BI.

    Screenshot that shows Azure Data Explorer web UI query to Power BI.

  3. A window appears with the following notification:

    export query to clipboard.

  4. Open Microsoft Excel.

  5. In the Data tab, select Get Data > From Other Sources > Blank Query.

    Get data and select blank query.

  6. The Power Query Editor window opens. In the window, select Advanced Editor.

    Power query editor window.

  7. In the Advanced Editor window, paste the query you exported to the clipboard and select Done.

    Advanced editor query.

  8. To authenticate, select Edit Credentials.

    Edit credentials.

  9. Select Organizational account and Sign in. Complete the sign-in process and then select Connect.

    Complete sign-in.

    Repeat the previous steps to add more queries. You can rename the queries to more meaningful names.

  10. Select the Close & Load button to get your data into Excel.

    Select close and load.

  11. Now your data is in Excel. Select the Refresh button to refresh the query.

    View data in excel.

Related content