Unable to install connector for Power Bi and PostgreSQL

+1 vote

Hello all. Please help me with my problem. It's driven me nuts!

I am using Microsoft Power Bi and trying to connect to a PostgreSQL database. But, when I go to Get Data, it says that the connector requires one or more additional components to be installed before it can be used.

My Microsoft Power Bi is at the version 2.47.4766.801 64-bit and Npgsql is at version 3.2.3. Also, I have VS Studio 2017 Community installed and used the VS Studio command prompt to add the dll files to the assembly. And, the following is my edited my machine.config file:
<system.data>
  <DbProviderFactories>
    <add name="Npgsql Data Provider" invariant="Npgsql" description=".Net Framework Data Provider for PostgreSQL Server" type="Npgsql.NpgsqlFactory, Npgsql, Version=3.2.3.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"/>
  </DbProviderFactories>
</system.data>
Plus, I also have .NET framework 4.5 installed as I am using Windows 10.  And, even after rebooting and trying it multiple times, I still keep getting the same message and thus, have been unable to connect as yet.

So, if anybody has got any clues at all on what's going on, then please help me in getting this thing to work, or at least point out where I could be going wrong, or just give me some directions to work on. Any help is much appreciated. Thanks in Advance!

Aug 22, 2018 in Power BI by Bharani
• 4,660 points

recategorized Aug 23, 2018 by Vardhan 2,698 views

1 answer to this question.

0 votes

I think the problem is not at your end, and that is the reason you're having such a hard time getting it to work. The problem seems to be in the latest versions of Npgsql. I tried it too and could connect with Npgsql 3.1.8 version, but not the newer ones. So, uninstalling your existing version and installing the version 3.1.8 and restarting should solve your problem to get you up and running. :)

Supercharge your business intelligence skills with our MSBI Course – Enroll now!

answered Aug 22, 2018 by nirvana
• 3,130 points

Related Questions In Power BI

0 votes
1 answer

How to install and setup power BI?

Installation and Set up Listed below are a ...READ MORE

answered Nov 11, 2020 in Power BI by Gitika
• 65,890 points
822 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
1,622 views
0 votes
1 answer

Is government, academic and nonprofit pricing available for Power BI?

Yes, nonprofit pricing is available when purchasing ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 52,350 points
568 views
0 votes
1 answer

Are 2 MM rows too much data for Power BI Online to manage?

PowerBI can easily handle 400MM rows and ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 52,350 points
1,071 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

answered Feb 28, 2019 in Power BI by Cherukuri
• 33,030 points
993 views
0 votes
1 answer

How to categorize state, pin and city in power bi (Address)

After loading dataset, you can split in ...READ MORE

answered May 10, 2019 in Power BI by anonymous
• 33,030 points
3,470 views
0 votes
1 answer

Power BI : npgsql installation

As a general rule Npgsql can be ...READ MORE

answered Nov 27, 2018 in Power BI by Shubham
• 13,490 points
7,507 views
0 votes
1 answer

Power BI Desktop : Npgsql 3.0.3 error

You can fix this issue by installing the ...READ MORE

answered Dec 14, 2018 in Power BI by Upasana
• 8,620 points
1,049 views
0 votes
2 answers

Install postgreSQL on Ubuntu

Follow the below commands to install PostgreSQL (PSQL) ...READ MORE

answered Nov 12, 2020 in Database by Prachi
• 140 points
1,221 views
0 votes
1 answer

Access progrs prompt without switching accounts

Use the following to get the postgres prompt ...READ MORE

answered Mar 22, 2019 in Database by Mahi
821 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP