Edit

Share via

Visualize data in a Power BI report

  • Article

In this article, you learn how to build a Power BI report using a KQL Queryset. The output of your query is used as the semantic model of your report.

To use multiple tables to build your Power BI report, see Use data from a KQL database in Power BI Desktop.

Prerequisites

Create a report

There are three possible ways to create a report:

  1. Option 1: Browse to a KQL queryset.

  2. Option 2: Open the Explore your data window from a KQL database.

    1. Write and select the query you want to build into a Power BI report. The output of this query is used as the semantic model for building the report.

    2. From the Explore your data window, select Power BI.

      Screenshot of query editor showing an example query. The Power BI option is highlighted.

  3. Option 3: On the ribbon, select Power BI.

  4. Create a report from an entire table. Browse to a KQL database.

    1. Select the More menu [...] of the table you want to use for the report.
    2. Select Power BI.

    Screenshot of building a Power BI report from a table. The table menu is open with Build Power BI report selected.

Note

When you build a report, a semantic model is created and saved in your workspace. You can create multiple reports from a single semantic model.

If you delete the semantic model, your reports will also be removed.

Report preview

You can add visualizations in the report's preview. In the Data pane, expand Kusto Query Result to see a summary of your query. For more information, see Power BI visualizations.

When you're satisfied with the visualizations, select File on the ribbon, and then Save this report to name and save your report in a workspace.

Screenshot of Power BI report preview window showing a preview of the semantic model visualization. The Save button is highlighted.

Report details

  1. In Name your file in Power BI, give your file a name.

  2. Select the workspace in which to save this report. The report can be a different workspace than the one you started in.

    Screenshot of report details showing the report's name and the workspace it's saved in. The button titled Continue is highlighted.

  3. Select the sensitivity label to apply to the report. For more information, see sensitivity labels.

  4. Select Continue.

Manage report

To view and edit your report, select Open the file in Power BI to view, edit, and get a shareable link.

Screenshot of report preview showing that the report has been saved. The link to open the report in Power BI is highlighted.

Next step

Visualizations in Power BI reports