Edit

Share via

Real-Time Intelligence tutorial part 6: Create a Power BI report

  • Article

Note

This tutorial is part of a series. For the previous section, see: Tutorial part 5: Create a Real-Time dashboard.

A Power BI report is a multi-perspective view into a semantic model, with visuals that represent findings and insights from that semantic model. In this section, you use a KQL query output to create a new Power BI report.

Build a Power BI report

  1. Browse to the KQL database you created in a previous step, named Tutorial.

  2. In the object tree, under the KQL database name, select the query workspace called Tutorial_queryset.

  3. Copy and paste the following query into the query editor. The output of this query is used as the semantic model for building the Power BI report.

    RawData
| summarize arg_max(Timestamp, No_Bikes,  No_Empty_Docks, Neighbourhood, Lat=todouble(Latitude), Lon=todouble(Longitude)) by BikepointID

  4. Select Create Power BI report. The Power BI report editor opens with the query result available as a data source named Kusto Query Result.

Add visualizations to the report

  1. In the report editor, select Visualizations > Stacked column chart icon.

  2. Drag the following fields from Data > Kusto Query Result to the Visualizations pane.

    • Neighbourhood > X-axis
    • No_Bikes > Y-axis
    • No_Empty_Docks > Y-axis

    Screenshot of adding the second visual, a column chart, to the report.

Save the report

  1. In the top left corner of the ribbon, select File > Save.
  2. Enter the name TutuorialReport. Choose your workspace, and set sensitivity as Public.
  3. Select Continue.
  4. Select Open the file in Power BI to view, edit, and get a shareable link.

Related content

For more information about tasks performed in this tutorial, see:

Next step

Tutorial part 6: Set an alert on your eventstream