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