Skip to content

Latest commit

 

History

History
91 lines (55 loc) · 4.55 KB

power-bi-connector.md

File metadata and controls

91 lines (55 loc) · 4.55 KB
title description services author ms.author ms.reviewer ms.service ms.topic ms.date
Quickstart: Visualize data using the Azure Data Explorer connector for Power BI
In this quickstart, you learn how to use one of the three options for visualizing data in Power BI: the Power BI connector for Azure Data Explorer.
data-explorer
orspod
v-orspod
mblythe
data-explorer
quickstart
11/14/2018

Quickstart: Visualize data using the Azure Data Explorer connector for Power BI

Azure Data Explorer is a fast and highly scalable data exploration service for log and telemetry data. Power BI is a business analytics solution that lets you visualize your data and share the results across your organization.

Azure Data Explorer provides three options for connecting to data in Power BI: use the built-in connector, import a query from Azure Data Explorer, or use a SQL query. This quickstart shows you how to use the built-in connector to get data and visualize it in a Power BI report.

If you don't have an Azure subscription, create a free Azure account before you begin.

Prerequisites

You need the following to complete this quickstart:

Get data from Azure Data Explorer

First, you connect to the Azure Data Explorer help cluster, then you bring in a subset of the data from the StormEvents table. [!INCLUDE data-explorer-storm-events]

  1. In Power BI Desktop, on the Home tab, select Get Data then More.

    Get data

  2. Search for Azure Data Explorer, select Azure Data Explorer (Beta) then Connect.

    Search and get data

  3. On the Preview connector screen, select Continue.

  4. On the next screen, fill out the form with the following information.

    Cluster, database, table options

    Setting Value Field description
    Cluster https://help.kusto.windows.net The URL for the help cluster. For other clusters, the URL is in the form https://<ClusterName>.<Region>.kusto.windows.net.
    Database Leave blank A database that is hosted on the cluster you're connecting to. We'll select this in a later step.
    Table name Leave blank One of the tables in the database, or a query like `StormEvents
    Advanced options Leave blank Options for your queries, such as result set size.
    Data connectivity mode DirectQuery Determines whether Power BI imports the data or connects directly to the data source. You can use either option with this connector.

  5. If you don't already have a connection to the help cluster, sign in. Sign in with an organizational account, then select Connect.

    Sign in

  6. On the Navigator screen, expand the Samples database, select StormEvents then Edit.

    Select table

    The table opens in Power Query Editor, where you can edit rows and columns before importing the data.

  7. In the Power Query Editor, select the arrow next to the DamageCrops column then Sort descending.

    Sort DamageCrops descending

  8. On the Home tab, select Keep Rows then Keep Top Rows. Enter a value of 1000 to bring in the top 1000 rows of the sorted table.

    Keep top rows

  9. On the Home tab, select Close & Apply.

    Close and apply

Visualize data in a report

[!INCLUDE data-explorer-power-bi-visualize-basic]

Clean up resources

If you no longer need the report you created for this quickstart, delete the Power BI Desktop (.pbix) file.

Next steps

[!div class="nextstepaction"] Quickstart: Visualize data using an imported query in Power BI