Cannot install Microsoft Power Bi Postgre SQL connector

0 votes

I am trying to use Microsoft Power Bi to connect to a PostgreSQL database.

When I go to Get Data it just says that the connector requires one or more additional components to be installed before it can be used

  1. I have installed Microsoft Power Bi version: 2.47.4766.801 64-bit (June 2017).
  2. I have installed Npgsql 3.2.3.
  3. I have installed VS Studio 2017 Community and added the dll files to the assembly using the VS Studio command prompt.
  4. I have edited my machine.config file.

below

<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>
  1. I am running Windows 10 so I already have .NET framework 4.5 installed.  6. I restart my PC, open up Power Bi and try to connect to Postgre again and I get the same message that the connector requires one or more additional components to be installed before it can be used.

The tracer log from my Power Bi can be found here:

How can I get this thing to work?

    Dec 22, 2020 in Power BI by Rajiv
    • 8,910 points
    805 views

    1 answer to this question.

    0 votes

    There seems to be some problem with the latest Npgsql versions.
    Succeded to connect with Npgsql 3.1.8 version.
    First uninstall the existing version then install and restart.

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

    answered Dec 22, 2020 by Gitika
    • 65,890 points

    Related Questions In Power BI

    0 votes
    2 answers

    Embed Microsoft Power BI into Liferay

    HI... Embed Microsoft Power BI into Liferay- I HOPE ...READ MORE

    answered Jul 15, 2020 in Power BI by anonymous
    2,036 views
    0 votes
    1 answer

    Install Power BI Desktop

    It’s a pretty simple process. All you ...READ MORE

    answered Oct 9, 2018 in Power BI by Kalgi
    • 52,360 points
    973 views
    0 votes
    1 answer

    How is Power BI Report Server different from SQL Server Reporting Services and the Power BI online service

    Power BI report server is deployed on-premises ...READ MORE

    answered Oct 15, 2018 in Power BI by Hannah
    • 18,540 points
    1,199 views
    0 votes
    1 answer

    Convert an expression from SQL to Power BI

    Use the following expression: MyTemperatureTable = FILTER ( Device1234, ...READ MORE

    answered Oct 22, 2018 in Power BI by Hannah
    • 18,540 points
    614 views
    +1 vote
    1 answer

    Unable to install connector for Power Bi and PostgreSQL

    I think the problem is not at ...READ MORE

    answered Aug 22, 2018 in Power BI by nirvana
    • 3,130 points
    2,681 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,450 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,014 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,173 views
    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
    801 views
    0 votes
    3 answers

    How to create final table based on Joins of two tables in power BI?

    To do so, follow these steps: From the ...READ MORE

    answered Dec 16, 2020 in Power BI by Gitika
    • 65,890 points
    55,773 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