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

Related Articles

Visualize data anomalies in real-time events sent to Azure Event Hubs (Microsoft Documentation)