Edit

Create Power Apps application to query data in Azure Data Explorer

  • Article
  • 3 minutes to read

Azure Data Explorer is a fast, fully managed data analytics service for real-time analysis of large volumes of data streaming from applications, websites, IoT devices, and more.

Power Apps is a suite of apps, services, connectors, and data platform that provides a rapid application development environment to build custom apps that connect to your business data. The Power Apps connector is useful if you have a large and growing collection of streaming data in Azure Data Explorer and want to build a low code, highly functional app to make use of this data. In this article, you'll create an Power Apps application to query Azure Data Explorer data. During this process, you'll see the steps of data parameterization, retrieval, and presentation.

Prerequisites

Connect to Azure Data Explorer Connector

  1. Navigate to https://make.powerapps.com/ and sign-in.

  2. On the left menu, select Dataverse > Connections.

  3. Select + New connection.

    Screenshot of the connections page, highlighting the create a new connection button.

  4. Search for Azure Data Explorer in the search bar. Select Azure Data Explorer from the resulting options.

    Screenshot of the new connection page, showing the search and select Azure Data Explorer connection.

  5. Select Create on the Azure Data Explorer popup. Provide credentials as required.

    Screenshot of the Azure Data Explorer connection dialog box, highlighting the create button.

Create App

  1. On the left menu, select Apps.

  2. Select + New app > Canvas in the menu bar.

    Screenshot of the apps page, showing the create a new canvas app button.

  3. Provide an app name, and under Format, select Tablet.

    Screenshot of the new app page, showing highlighting the tablet layout option.

Add Connector

  1. On the left menu, select Data.

  2. Select Add data, expand Connectors, and then elect Azure Data Explorer.

    Screenshot of the app page, showing the add connector to Azure Data Explorer option.

Under Data, you'll now see the Azure Data Explorer app in the list of connectors.

Screenshot of the app page, showing the Azure Data Explorer in the list of data connectors.

Save Your App

  1. Select File in the menu bar.

  2. Select Save in the left-hand navigation.

    Screenshot of the app page, showing the save button.

  3. Enter a meaningful name for your app. Select the Save button in the lower right.

Advanced Settings

  1. On the left menu, select Settings.

  2. Select Advanced settings.

  3. Select Dynamic schema from resulting options. Enable this feature.

    Screenshot of the settings page, showing the turn on dynamic schema setting.

  4. Search for the Data row limit for non-delegable queries setting. Set your returned records limit.

    Screenshot of the settings page, showing the return results limit setting.

    Note

    The default limit is 500, with a maximum of 2,000 returned records.

Important

Save your app again and restart as required.

Add Dropdown

  1. Select Insert in the menu bar.

  2. Select Input in the resulting sub menu bar.

  3. Select Drop down in the resulting dropdown.

  4. Select on the Advanced tab in the right-hand popout.

  5. Populate the Items input box with: ["CALIFORNIA","MICHIGAN"]

    Screenshot of the app page, showing the populate items in dropdown menu.

  6. With the dropdown still selected, select OnChange from the Property dropdown in the formula bar.

  7. Enter the following formula:

    ClearCollect(
Results,
AzureDataExplorer.listKustoResultsPost(
"https://help.kusto.windows.net",
"Samples",
"StormEvents | where State == '" & Dropdown1.SelectedText.Value & "' | take 15"
).value
)

  8. Select the Capture schema button. Allow time for processing.

    Screenshot of the app page, showing the select capture schema button in the dropdown menu.

Add Data Table

  1. Select Insert in the menu bar.

  2. Select Data table in the resulting sub menu bar.

  3. Reposition the data table and consider adding a border for visibility.

  4. Select the Properties tab in the right-hand popout. Select Results from the Data Source dropdown.

  5. Select Edit fields link.

  6. Select + Add field in the resulting popout.

    Screenshot of the app page, showing the repositioning of a table and adding border.

  7. Select desired fields and select Add button. A preview of the selected data table appears.

    Screenshot of the app page, showing a preview of the table populated with data.

Validate

  1. Select the Preview the app button in the upper right of the screen.

  2. Try the dropdown, scroll through the data table, and confirm successful data retrieval and presentation.

    Screenshot of the app page, showing a preview the new app with data from Azure Data Explorer.

Limitations

  • Power Apps has a limit of up to 2,000 results records returned to the client. The overall memory for those records can't exceed 64 MB and a time of seven minutes to run.
  • The connector doesn't support the fork and facet operators.
  • Timeout exceptions: The connector has a timeout limitation of 7 minutes. To avoid potential timeout issue, make your query more efficient so that it runs faster, or separate it into chunks. Each chunk can run on a different part of the query. For more information, see Query best practices.

Next steps

Learn about the Azure Kusto Logic App connector, which is another way to run Kusto queries and commands automatically, as part of a scheduled or triggered task.