I am trying to use Microsoft Power Bi to connect to a PostgreSQL database.
When I go to Get Data , it just says that one or more additional components are required for the connection before it can be used
- I installed the Microsoft Power Bi version: 2.47.4766.801 64-bit (June 2017).
- I installed Npgsql 3.2.3.
- I installed VS Studio 2017 Community and added the dll files to the assembly using the VS Studio command line.
I edited the 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>
I am running Windows 10, so I already have the .NET framework 4.5 installed. 6. I reboot my computer, open Power Bi and try to connect to Postgre again, and I get the same message that it requires one or more additional components 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 make this work work? It drives me crazy! Thanks
source
share