In Peliqan, go to Connections, find the Data Warehouse tile and copy/paste your connection details:
Use these settings in Microsoft Power BI to connect:
db.eu.peliqan.io
(for EU instance)In Power BI, click on “Get Data” and then “More” or “Get data from another source”.
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: