For Materialized tables: in Peliqan go to Connections, find the tile named “Sync Data warehouse” and copy & paste all the details from the Target:
For SaaS sources: in Peliqan go to Connections, find the tile of the SaaS connection and copy & paste all the details from the Target:
Use these settings in Power BI to connect:
- Connection type: Postgres (default data warehouse type in Peliqan)
- Server: db.eu.peliqan.io (for EU instance)
- User name & password: copy / paste from the Target of the Connection tile (see above)
- Database name: same as the user name
- SSL: enabled
Demo video
Step by step
In Power BI, click on “Get Data” and then “More”. Select PostgreSQL from the list:
Paste the host name from the Peliqan data warehouse, e.g. db.eu.peliqan.io
, the database name and click OK:
On the next screen, enter the database name from Peliqan and select “DirectQuery”. Note that the database name is the same as the user name (login). On the next screen, enter the login and password from Peliqan:
Select the tables to include in Power BI:
You can now build charts in Power BI: