Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I am currently running the latest version of the Power BI Desktop [2.39.4526.362 64-bit (September, 2016)] on Windows 8.1. I would like to connect to a PostgreSQL database (in this case Amazon RDS) but I am running into a seemingly intractable problem. When I click on "Get Data...More...PostgreSQL Database" from the ribbon I immediately get the following error:
Originally I did not have the npgsql .NET data provider installed. So I dutifully downloaded and installed the latest version of npgsql data provider (https://github.com/npgsql/npgsql/releases/download/v3.1.8/Npgsql-3.1.8.msi). I then rebooted my PC and tried again to configure a PostgreSQL data source. Same error dialog appears. I have subsequently tried installing several older versions of npgsql in place of 3.1.8, notably 3.1.7 and 2.2.3. In all cases I have run the installer to push the npgsql.dll and mono.security.dll files into the Global Assembly Cache using the Visual Studio 2015 Tools Command Prompt:
gacutil.exe -i Npgsql.dll gacutil.exe-i Mono.Security.dll
I still get the same error.
Anyone having similar issues?
Hi @peter-townsend,
Based on my test for Power BI Desktop version 2.39.4526.362 64-bit, once I run Npgsql-3.1.8.msi to install the provider and restart the computer, we are able to open the PostgreSQL Database navigator.
In your scenario, please check if you have installed .NET 4.5 or higher version in the computer. Also please check if you can find any useful information in desktop trace log.
Best Regards,
Qiuyun Yu
Did you solve this @peter-townsend?
I followed the exact same steps as @peter-townsend. It still did not work. I followed the steps from @ankitpatira to troubleshoot, still did not work.
<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>
5. 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.
Ian
Someone very kindly helped me fix this. It works now.
https://stackoverflow.com/questions/44793519/cannot-install-microsoft-power-bi-postgre-sql-connector
This is insane Microsoft. Pay the man to make an install that connects his software to Power BI handling ALL problems. PostgreSQL is the 4th most widely used database. You need to make this seemless Microsoft. Someone already went to the trouble of doing most of the hard connectivity work for free. You need to fund him to deal with the PITA nonsense part that is the difference between Power BI being The GoTo BI product for PostgreSQL, and what it currently is (only used by gluttons for punishment or the lucky who happened to have all the right combination of software versions that make it magically work).
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
42 | |
25 | |
14 | |
14 | |
12 |