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

Answer 1

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