<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>

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