content/shared/influxdb3-visualize/powerbi.md
Use Microsoft Power BI Desktop 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.
{{% cite %}}-- Microsoft Power BI documentation{{% /cite %}}
[!Important] These instructions are for Power BI Desktop only; it uses a custom connector.
The InfluxDB 3 custom connector for Power BI requires the Arrow Flight SQL ODBC driver. Install the driver before installing the Power BI connector.
<a class="btn" href="https://docs.influxdata.com/downloads/apache-arrow-flight-sql-odbc-1.0.0-win64.msi">Download the Arrow Flight SQL ODBC driver</a>
.msi installer.After installing the ODBC driver, download and install the InfluxDB 3 custom connector for Power BI Desktop.
<a class="btn" href="https://docs.influxdata.com/downloads/InfluxDB.pqx">Download the InfluxDB 3 Power BI connector</a>
Create the custom connectors folder if it doesn't exist:
mkdir "$env:USERPROFILE\Documents\Power BI Desktop\Custom Connectors"
Move the connector file to the custom connectors folder:
{{% code-placeholders "YOUR_USER" %}}
Move-Item "C:\Users\YOUR_USER\Downloads\InfluxDB.pqx" `
"$env:USERPROFILE\Documents\Power BI Desktop\Custom Connectors\"
{{% /code-placeholders %}}
Replace the following:
YOUR_USER{{% /code-placeholder-key %}}: Your Windows usernameTo use custom connectors, you must adjust Power BI Desktop's security settings:
[!Warning]
Security considerations
Enabling uncertified extensions allows any custom connector to load. Only enable this setting if you trust the connectors you're installing.
After installing the connector and restarting Power BI Desktop:
Open Power BI Desktop
Click Get Data > More
Search for InfluxDB 3 and select it
Click Connect
In the InfluxDB 3 connection dialog, configure the following:
https://us-west-2-1.aws.cloud2.influxdata.com{{% /show-in %}}{{% show-in "cloud-dedicated" %}}https://cluster-id.a.influxdb.io{{% /show-in %}}{{% show-in "clustered" %}}https://cluster-host.com{{% /show-in %}}{{% show-in "enterprise,core" %}}http://localhost{{% /show-in %}})443 (HTTPS){{% /show-in %}}{{% show-in "enterprise,core" %}}8181 (default){{% /show-in %}})Select DirectQuery as the Data Connectivity mode
Click OK
When prompted for credentials:
Click Connect
Preview your data and click Load
[!Important]
Limit query size for optimal performance
{{% product-name %}} can handle high throughput and dimensional data. To ensure Power BI can successfully process data, limit query size by:
- Using a
LIMITclause- Specifying time ranges with
WHERE time >= ...- Filtering by specific columns or tags
When connecting to InfluxDB 3, you can use the Native Query option to execute custom SQL queries:
In the connection dialog, enable Native Query
Enter your query in the provided field:
SELECT
time,
temp,
room
FROM
home
WHERE
time >= now() - INTERVAL '7 days'
ORDER BY
time DESC
LIMIT 1000
Select DirectQuery as the connectivity mode
Click OK to load the data
After loading data, Power BI displays your dataset in the Fields pane.
time fieldtemp)room)time column for time-based visualizationstime columnLIMIT clause to restrict the number of rows returnedIf Power BI or other applications can't find the Arrow Flight SQL ODBC driver:
If Power BI Desktop doesn't show the InfluxDB 3 connector:
.pqx file is in the correct location:
Documents\Power BI Desktop\Custom Connectors\If you encounter connection errors:
http://localhost:8181443{{% /show-in %}}UseEncryption is configured correctly for your connection typeIf authentication fails:
If queries fail or return errors:
LIMIT clausesFor better query performance:
WHERE clauses to filter data before loadingWHERE time >= now() - INTERVAL '7 days') to limit the data scannedLIMIT clause to restrict result size