---
title: Use Power BI to visualize data
description: Use Microsoft Power BI Desktop with the InfluxDB 3 custom connector to query and visualize data from InfluxDB 3 Enterprise.
url: https://docs.influxdata.com/influxdb3/enterprise/visualize-data/powerbi/
estimated_tokens: 1259
product: InfluxDB 3 Enterprise
version: enterprise
---

# Use Power BI to visualize data

-   SQL

Use [Microsoft Power BI Desktop](https://powerbi.microsoft.com/) with the This guide includes Windows (64‑bit) installation steps for the Arrow Flight SQL ODBC driver and the InfluxDB 3 Power BI connector.

> Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.
> 
> – [Microsoft Power BI documentation](https://learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview)

These instructions are for Power BI Desktop only; it uses a custom connector.

1. [Prerequisites](#prerequisites)
2. [Install the Arrow Flight SQL ODBC driver](#install-the-arrow-flight-sql-odbc-driver)
3. [Install the Power BI connector](#install-the-power-bi-connector)
4. [Enable the connector in Power BI](#enable-the-connector-in-power-bi)
5. [Connect Power BI to InfluxDB](#connect-power-bi-to-influxdb)
6. [Query and visualize data](#query-and-visualize-data)

## Prerequisites

-   **Windows operating system**: The custom connector requires Windows (macOS users can use virtualization software like [Parallels](https://www.parallels.com/))
-   **Power BI Desktop**: [Download and install Power BI Desktop](https://powerbi.microsoft.com/desktop/) (A free trial is available)
-   **InfluxDB 3 Enterprise**: A running instance with data to query
-   **Database token**: Your

with query permissions for the target database

## Install the Arrow Flight SQL ODBC driver

The InfluxDB 3 custom connector for Power BI requires the Arrow Flight SQL ODBC driver. Install the driver before installing the Power BI connector.

[Download the Arrow Flight SQL ODBC driver](https://docs.influxdata.com/downloads/apache-arrow-flight-sql-odbc-1.0.0-win64.msi)

1. Run the downloaded `.msi` installer.
2. Follow the installation wizard using default settings.
3. Complete the installation.

#### Verify driver installation

1. Open the Windows application [ODBC Data Source Administrator (64-bit)](https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/open-the-odbc-data-source-administrator).
2. Open the [ODBC Data Source Administrator (64-bit) Windows component](https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/open-the-odbc-data-source-administrator)
3. Navigate to the **Drivers** tab
4. Verify **Arrow Flight SQL ODBC Driver** appears in the list.

## Install the Power BI connector

After installing the ODBC driver, download and install the InfluxDB 3 custom connector for Power BI Desktop.

[Download the InfluxDB 3 Power BI connector](https://docs.influxdata.com/downloads/InfluxDB.pqx)

### Move the connector to the custom connectors directory

1. Create the custom connectors folder if it doesn’t exist:
    
    ```powershell
    mkdir "$env:USERPROFILE\Documents\Power BI Desktop\Custom Connectors"
    ```
    
2. Move the connector file to the custom connectors folder:
    
    ```powershell
    Move-Item "C:\Users\YOUR_USER\Downloads\InfluxDB.pqx" `
    
    ```
    

`"$env:USERPROFILE\Documents\Power BI Desktop\Custom Connectors"`