In Peliqan, go to Connections, find the Data Warehouse tile and copy/paste your connection details:

Data warehouse details.png

Use these settings in Microsoft Power BI to connect:

Step by step

In Power BI, click on “Get Data” and then “More” or “Get data from another source”.

Select PostgreSQL from the list:

1 - MS Power BI select Postgres data warehouse.png

Paste the host name from the Peliqan data warehouse, e.g. db.eu.peliqan.io , the database name and click OK:

MS Power BI set server and database.png

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: