# Sending Data to Power BI

> In this topic you can learn how to leverage the Insights real-time data export feature to send data to Microsoft Power BI and report on it there.

## Overview

In this topic you can learn how to leverage the Insights real-time data export feature to send data to Microsoft Power BI and report on it there.

:::note
[Configure real-time data export](https://docs.uipath.com/insights/automation-cloud/latest/user-guide/configure-real-time-data-export#configure-real-time-data-export) before configuring your Microsoft Power BI reporting.
:::

## Create Azure Stream Analytics job

Create and configure a resource in Azure to consume Insights data.

1. Sign in to `portal.azure.com`
2. Create a **Stream Analytics job**.
   a. Select the desired resource group.
   b. Select **Create a resource**.
   c. Select **Analytics** > **Stream Analytics job** and fill in the required information.
3. Add an input for the **Stream Analytics job**.
   a. Go to **Stream Analytics job**.
   b. Select **Input** > **Add input**.
   c. Select the required Azure Event Hub and create a new consumer group.
4. Add an output for the **Stream Analytics job**.
5. Configure **Job Query** by either:
   * Getting all the events in the stream:
     ```
     SELECT
         Timestamp,
         EventType,
         FolderName, 
         Job.ProcessName as ProcessName,
         Job.State as State,
         Job.RobotName as RobotName,
         Job.HostMachineName as HostMachineName,
         Job.[Key] as JobKey,
         Job.StartTime as JobStartTime,
         Job.EndTime as JobEndTime,
         Job.DisplayName as ProcessDisplayName
     INTO
         [location-output]
     FROM
         [location-input] TIMESTAMP BY [Timestamp]
     WHERE
         EventType like '%job.%'
     ```
   * Projecting and aggregating the input. The following query retrieves event types by time and type, offering improved performance for large datasets in Power BI:
     ```
     SELECT
         System.Timestamp AS WindowEnd,
         [EventType],
         count(*) as EventCount
     INTO
         [Location]
     FROM
         [location]
     GROUP BY TumblingWindow(Duration(second, 1)), EventType
     ```
6. Test the query for an end-to-end data flow, verifying a proper authorization of inputs and outputs.
7. Start the **Stream Analytics job**.
   a. Go to **Stream Analytics job Overview**.
   b. Select **Start**.

## Visualize Insights data in Power BI

Use the dataset in Azure to visualize Insights data in Power BI.

Sign in to Power BI and [create a report based on a published dataset](https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-discover-across-workspaces).

![Screenshot of the Power BI interface.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-docs-image-158618-0581ad26-59c7dd94.webp)

## Related Articles

[Visualize data anomalies in real-time events sent to Azure Event Hubs](https://learn.microsoft.com/en-us/azure/event-hubs/event-hubs-tutorial-visualize-anomalies) (Microsoft Documentation)