Power BI

In this article, you can learn how to get data from Power BI to Canner Enterprise.

Set Canner Enterprise as a Power BI data source

info

Currently, only Import Mode is supported

1. In Get Data, select PostgreSQL Database connection

2. Enter connection information

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

Workspace SQL Name

You can see the Workspace SQL Name in the workspace list

3. Enter user/password

Password input Personal Access Token

4. Load Data

After the connection is successful, a window will pop up to display all available Tables/ Views/ Materialized Views in the Workspace

5. Getting Started

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