---
title: Integrate Power BI with Tiger Cloud | Tiger Data Docs
description: Create interactive reports and dashboards to analyze and share insights from your data
---

[Power BI](https://www.microsoft.com/en-us/power-platform/products/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 Tiger Cloud using the PostgreSQL ODBC driver, so that you can build interactive reports based on the data in your Tiger Cloud service.

## Prerequisites

To follow the procedure on this page you need to:

- Create a [target Tiger Cloud service](/docs/get-started/quickstart/create-service/index.md).

  This procedure also works for [self-hosted TimescaleDB](/docs/get-started/choose-your-path/install-timescaledb/index.md).

* Download [Power BI Desktop](https://www.microsoft.com/en-us/power-platform/products/power-bi/downloads) on your Microsoft Windows machine.
* Install the [PostgreSQL ODBC driver](https://www.postgresql.org/ftp/odbc/releases/).

## Add your service as an ODBC data source

Use the PostgreSQL ODBC driver to connect Power BI to Tiger Cloud.

1. **Open the ODBC data sources**

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

2. **Connect to your Tiger Cloud service**

   1. Under `User DSN`, click `Add`.
   2. Choose `PostgreSQL Unicode` and click `Finish`.
   3. Use your [connection details](/docs/integrate/find-connection-details/index.md) 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 Tiger Cloud service into Power BI:

1. **Connect Power BI to your Tiger Cloud service**

   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 Tiger Cloud data source and click `OK`.
   4. Use your [connection details](/docs/integrate/find-connection-details/index.md) 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 Tiger Cloud.