> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Integrate Power BI with Tiger Cloud

> Create interactive reports and dashboards to analyze and share insights from your data

export const PG = 'Postgres';

export const CLOUD_LONG = 'Tiger Cloud';

export const SERVICE_LONG = 'Tiger Cloud service';

export const SELF_LONG = 'self-hosted TimescaleDB';

[Power BI][power-bi] is a business analytics tool for visualizing data, creating interactive reports, and sharing insights across an organization.

This page explains how to integrate Power BI with {CLOUD_LONG} using the {PG} ODBC driver, so that you can build interactive reports based on the data in your {SERVICE_LONG}.

## Prerequisites

To follow the steps on this page:

* Create a target [{SERVICE_LONG}][create-service] with Real-time analytics enabled.<p />

  You need [your connection details][connection-info]. This procedure also
  works for [{SELF_LONG}][enable-timescaledb].

[create-service]: /deploy-and-operate/tiger-cloud/get-started/create-services

[enable-timescaledb]: /deploy-and-operate/self-hosted/install-and-update/install-self-hosted

[connection-info]: /integrations/find-connection-details

* Download [Power BI Desktop][power-bi-install] on your Microsoft Windows machine.
* Install the [PostgreSQL ODBC driver][postgresql-odbc-driver].

## Add your service as an ODBC data source

Use the PostgreSQL ODBC driver to connect Power BI to {CLOUD_LONG}.

1. **Open the ODBC data sources**

   On your Windows machine, search for and select `ODBC Data Sources`.

2. **Connect to your {SERVICE_LONG}**

   1. Under `User DSN`, click `Add`.
   2. Choose `PostgreSQL Unicode` and click `Finish`.
   3. Use your [connection details][connection-info] to configure the data source.
   4. Click `Test` to ensure the connection works, then click `Save`.

## Import the data from your service into Power BI

Establish a connection and import data from your {SERVICE_LONG} into Power BI:

1. **Connect Power BI to your {SERVICE_LONG}**

   1. Open Power BI, then click `Get data from other sources`.
   2. Search for and select `ODBC`, then click `Connect`.
   3. In `Data source name (DSN)`, select the {CLOUD_LONG} data source and click `OK`.
   4. Use your [connection details][connection-info] to enter your `User Name` and `Password`, then click `Connect`.

   After connecting, `Navigator` displays the available tables and schemas.

2. **Import your data into Power BI**

   1. Select the tables to import and click `Load`.

      The `Data` pane shows your imported tables.

   2. To visualize your data and build reports, drag fields from the tables onto the canvas.

You have successfully integrated Power BI with {CLOUD_LONG}.

[connection-info]: /integrations/find-connection-details

[postgresql-odbc-driver]: https://www.postgresql.org/ftp/odbc/releases/

[power-bi]: https://www.microsoft.com/en-us/power-platform/products/power-bi/

[power-bi-install]: https://www.microsoft.com/en-us/power-platform/products/power-bi/downloads