Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot install Microsoft Power Bi Postgre SQL connector

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:

https://www.sendspace.com/file/vleze0

How can I get this thing to work?  It's driving me crazy!   Thanks

like image 987
ianwuk Avatar asked Jun 28 '17 04:06

ianwuk


People also ask

How do I enable live connect on Power BI?

Navigate to File > Options and settings > Options > Preview features and enable Power BI Service Live Connection. You'll need to restart Desktop in order for the option to take effect.

How does Power BI connect to OLE DB?

Access Power BI Desktop. Select Get Data > Other > OLE DB, and then select Connect. The From OLE DB window appears. Select Build.


1 Answers

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.

like image 200
igorc Avatar answered Oct 20 '22 22:10

igorc