How to connect Power BI to PostgreSQL

Question

I want get data into Power BI desktop from PostgreSQL (on my local machine). I tried the solution given here (Installing ngpsql to use PostgreSQL in PowerBI), but it did not work.

Basically, I installed the latest version of ngpsql(3.2.4) with the option to install to GAC. However, I'm getting the same error in Power BI saying that the connector requires one or more additional components.

Am I missing any steps? I looked online but did not find any recent documentation on this.

Any help is very much appreciated.

Thanks

Solution

Three ways :

1 - The ngpsql way does work if your follow the comment of Lavande:

1. Install npgsql as Administrator (since the DLL would be pushed to GAC);
2. During the installation stage, enabled "Npgsql GAC Installation";
3. Restart the PC

2 - With ODBC, i used this walk-through

• install ODBC connector here
• start it and create a new connection (DSN)
• in Power BI, get data, ODBC,PostGreSQL, no options
• enter the credentials.
• select the table(s) of interest.

3 - With the M query language.

Nota : the Power BI community posts ? well, ...

Comments

[Shay Rojansky]

Can you please try installing 3.2.4.1 and not 3.2.4? There was a versioning issue with 3.2.4

[Lavande]

I tried npgsql 3.2.5 and it worked. My steps as below: 1. Install npgsql as Administrator (since the DLL would be pushed to GAC); 2. During the installation stage, enabled "Npgsql GAC Installation"; 3. Restart the PC, then launch PowerBI. The connection should work.

[Manohar Reddy Poreddy]

Nov 2019 - A simple way to install is here - stackoverflow.com/a/59080365/984471

[loving_guy]

how is this answer relevant to Question asked by OP? he is asking solution to connect PostgreSQL to PowerBI.