Skip to main content
Version: v2

Power BI

info

Currently, only Import Mode is supported

1. In Get Data, select PostgreSQL Database connection

choose-pg

2. Enter connection information

pg-connect

  • Server: Enter IP/Host and Port
  • Database: Enter the SQL Name of the Workspace
Workspace SQL Name

The SQL Name location is in the Workspace; click the Share button and switch to the PostgreSQL Wire Protocol page. 1_power_bi

3. Enter user/password

pg-cred Password input Personal Access Token

4. Load Data

After the connection is successful, a window will pop up to display all available Table / View / Materialized Views in the Workspace pg-load-data

5. Getting Started

Then, you can use the data in Canner Enterprise in Power BI pg-pbi