Skip to content

power-bi-data-connector.md

Latest commit

 

History

History
70 lines (42 loc) · 3.75 KB

power-bi-data-connector.md

File metadata and controls

70 lines (42 loc) · 3.75 KB
title Connect KQL Database to Power BI Desktop
description Learn how to connect your KQL database as a data source in Power BI Desktop.
ms.reviewer tzgitlin
ms.topic how-to
ms.custom sfi-image-nochange
ms.date 11/19/2024

Connect KQL Database to Power BI Desktop

In this article, you learn how to connect your KQL database as a data source to Power BI Desktop. Once connected, you can use multiple tables to build your Power BI reports.

To create reports with Power BI service using a KQL queryset, see Create a Power BI report.

Prerequisites

Connectivity modes

Power BI supports Import and DirectQuery connectivity modes. When building Power BI reports, choose your connectivity mode depending on your scenario, scale, and performance requirements. Using Import mode copies your data to Power BI. In contrast, using DirectQuery mode queries your data directly from your KQL database.

Use Import mode when:

Use DirectQuery mode when:

  • Your data set is large or you need near real-time data.

For more information on connectivity modes, see Import and Direct Query connectivity modes.

Connect data source

  1. Launch Power BI Desktop.

  2. On the Home tab, select OneLake data hub > KQL Databases.

    :::image type="content" source="media/power-bi-data-connector/power-bi-desktop.png" alt-text="Screenshot of Power BI Desktop showing the dropdown menu of the OneLake data hub." lightbox="media/power-bi-data-connector/power-bi-desktop-extended.png" :::

    A list of KQL Databases that you have access to appears in the OneLake data hub window.

  3. Select a KQL database to use as a data source in Power BI, and then select Connect.

    :::image type="content" source="media/power-bi-data-connector/one-lake-data-hub.png" alt-text="Screenshot of OneLake data hub showing a list of KQL Database available for connection in Power BI Desktop.":::

  4. Provide your credentials in the authentication window.

Load data

  1. In the Navigator window, select the tables you want to connect, and then select Load.

    Optionally, if you want to shape your data first, select Transform data to launch the Power Query Editor. For more information, see Shape data.

    :::image type="content" source="media/power-bi-data-connector/navigator-pane.png" alt-text="Screenshot of the navigator pane showing the selected tables for connection.":::

    The Connection settings window that appears lists the data connectivity modes. The connectivity mode determines whether Power BI imports the data or connects directly to the data source. For more information, see Connectivity modes.

  2. Select DirectQuery to connect directly to the data source, and then select OK.

    :::image type="content" source="media/power-bi-data-connector/connection-settings.png" alt-text="Screenshot of the connection settings pane showing the two available connectivity modes. DirectQuery is selected.":::

You successfully connected your KQL database as a data source in Power BI Desktop. You can now visualize your data in a Power BI report.

Next step

[!div class="nextstepaction"] Create reports in Power BI