<aside> ☝ You cannot connect directly to data warehouses using Power BI Web (the online version in the browser), make sure to use Power BI Desktop.

</aside>

For Materialized tables: in Peliqan go to Connections, find the tile named “Sync Data warehouse” and copy & paste all the details from the Target:

Materialize target.png

For SaaS sources: in Peliqan go to Connections, find the tile of the SaaS connection and copy & paste all the details from the Target:

Hubspot target.png

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

https://youtu.be/KtQJtVC6bCA

Step by step

In Power BI, click on “Get Data” and then “More”. Select PostgreSQL from the list:

1 - MS Power BI select Postgres data warehouse.png