Search

Connectors

Contact support

Microsoft Power BI

Microsoft Power BI

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

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

image

Use these settings in Microsoft 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 Data Warehouse Connection tile (see above)
  • Database name: same as the user name
  • SSL: enabled

Step by step

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

Select PostgreSQL from the list:

image

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

image

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:

image
☝
When Power BI does not ask for a login and password, go to the Home menu ribbon, click on Transform Data and select “Data source settings” from the drop-down menu. Select the existing datasource and change its credentials, or remove it completely. Click here for more info.

Select the tables to include in Power BI:

image

You can now build charts in Power BI:

image

Troubleshooting

A recent Windows update (August/September 2024) might cause issues for Power BI to connect to Postgres. The Peliqan built-in data warehouse runs on Postgres.

You might get the error “Please install Npgsql version 4.0.10.0 or earlier” when doing a Refresh in Power BI Desktop:

image

In that case, please make sure to install the correct version of Npgsql on your Windows computer. Npgsql is the Postgres driver used by Power BI.

Download the MSI installer from this URL:

https://github.com/npgsql/npgsql/releases/tag/v4.0.10

During install, make sure to install in GAC (Windows Global Assembly Cache):

image

After install, reboot your computer !

Once you have rebooted, the Refresh in Power BI Desktop should work again.