insights
latest
false
- Getting Started
- Access and Permissions
- Notifications
- Interacting with Insights
- Action Center Integration
- Automation Hub Integration
- Autopilot integration
- Healing Agents integration
- License monitoring integrations
- Maestro Integration
- Test Manager Integration
- Real-time Monitoring
- Real Time Data Export
- Licensing
- Troubleshooting
Insights user guide
Last updated May 7, 2026
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. a. Select the desired resource group. b. Select Create a resource. c. Select Analytics > Stream Analytics job and fill in the required information.
- 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.
- 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
- Getting all the events in the stream:
- Test the query for an end-to-end data flow, verifying a proper authorization of inputs and outputs.
- 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)