Use TimescaleIntegrations

Integrate Power BI with Timescale Cloud

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 Timescale Cloud using the PostgreSQL ODBC driver, so that you can build interactive reports based on the data in your Timescale Cloud service.

Prerequisites

To follow the procedure on this page, you need to:

Add your Timescale Cloud service as an ODBC data source

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

  1. Open the ODBC data sources

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

  2. Connect to your Timescale Cloud service

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

Import the data from your your Timescale Cloud service into Power BI

Establish a connection and import data from your Timescale Cloud service into Power BI:

  1. Connect Power BI to your Timescale 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 Timescale Cloud data source and click OK.
    4. Use your connection details 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 Timescale Cloud.

Keywords

Power BIvisualizationsanalysisreal-time

Found an issue on this page?Report an issue or Edit this page in GitHub.

PreviousPrometheusNextpsql

Related Content

Using Tableau to visualize data in TimescaleDB
Tableau is a popular analytics platform that helps you gain greater intelligence about your business. Integrate Tableau with Timescale Cloud
Connect to a Timescale Cloud service with psql
psql enables you to type in queries interactively, issue them to Postgres, and see the query results. Connect to your Timescale Cloud service using psql
Integrate Datadog with Timescale Cloud
Datadog is a cloud-based monitoring and analytics platform. Export telemetry data from your Timescale Cloud service with time-series and analytics capability to Datadog
Integrate DBeaver with Timescale Cloud
DBeaver is a free cross-platform database tool for developers, database administrators, analysts, and everyone working with data. Integrate DBeaver with Timescale Cloud
Integrate pgAdmin with Timescale Cloud
pgAdmin is a feature-rich open-source administration and development platform for PostgreSQL. Integrate pgadmin with Timescale Cloud
Integrate qStudio with Timescale Cloud
qStudio is a modern free SQL editor that provides syntax highlighting, code-completion, excel export, charting, and much more. Integrate qStudio with Timescale Cloud