Insights
latest
false
Banner background image
Insights
Last updated Feb 23, 2024

Sending Data to Power BI

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 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.

    1. Select the desired resource group.
    2. Select Crate a resource.
    3. Select Analytics > Stream Analytics job and fill in the required information.
  3. Add an input for the Stream Analytics job.

    1. Go to Stream Analytics job.
    2. Select Input > Add input.
    3. 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.%'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)), EventTypeSELECT
          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.

    1. Go to Stream Analytics job Overview.
    2. Click Start.

Visualize Insights Data in Power BI

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



Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.