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.

Sign in to portal.azure.com
Create a Stream Analytics job.
1. Select the desired resource group.
2. Select Create a resource.
3. Select Analytics > Stream Analytics job and fill in the required information.
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.
Add an output for the Stream Analytics job.
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
```
Test the query for an end-to-end data flow, verifying a proper authorization of inputs and outputs.
Start the Stream Analytics job.
1. Go to Stream Analytics job Overview.
2. Click Start.