Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (6.1k points)
edited by

I am trying to get data into Power BI desktop from PostgreSQL on my personal machine. I tried many solutions, but they did not work.

Basically, I installed the latest version of ngpsql(3.2.4) with the option to install to GAC.                    But, I'm facing the same error in Power BI stating that:

 The connector requires one or more additional components.

1 Answer

0 votes
by (11.7k points)

Two ways are listed below to establish a connection between PowerBi and PostgreSQL:

 ngpsql:

  • Install npgsql as Administrator (since the DLL would be pushed to GAC);

  • During the installation stage, enabled "Npgsql GAC Installation";

  • Restart the PC

ODBC
  • Start and create a new connection (DSN)

  • in Power BI, get data, ODBC,PostGreSQL, no options

  • enter the specific credentials.

  • select the table(s) of interest.

Related questions

+1 vote
1 answer
0 votes
1 answer
asked Feb 10, 2021 in BI by Chris (11.1k points)
0 votes
0 answers
0 votes
1 answer
asked Mar 6, 2021 in Java by dante07 (13.1k points)

Browse Categories

...