Npgsql: Missing x64 installer/msi release?

[hkusulja]

Microsoft PowerBI Desktop is refering to this Npgsql, but it missing the x64bit installer / release for users.
Please add it to release version like it was before on web.
Thank you

[kenjiuno]

Hi.
The Npgsql GAC setup for example v3.2.1 covers both 32-bit and 64-bit applications in 2 meanings:

• Npgsql.dll is a processorArchitecture=MSIL assembly, so both 32-bit and 64-bit applications can load Npgsql.dll.
• It is registered as an ADO.NET data provider declared at C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config and C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

If you have experienced any problems, please feel free to post it! (Sorry, I don't know detail about PowerBI)

[roji]

Am going to close this as @kenjiuno answered above with all the info.

If you still have issues after installing the MSI, please provide more information about what's not working.

[hkusulja]

I have latest PowerBI desktop and Windows 10 latest, installed v.3.2.1 , and rebooted, still says it is missing...

[kenjiuno]

I have downloaded Power BI Desktop and tried it some time ago.
It seems to work correctly with Npgsql 3.2.1.

I'll confirm my steps to work with PostgreSQL 9.4 server, and then please check what's wrong on your side:

1. Launch Power BI Desktop
2. Open _Home_ tab of ribbon, at _External Data_ group, click __Get Data__
3. Click __More ...__ when drop-down shows.
4. Select __PostgreSQL Database__, and click __Connect__
5. Popup _PostgreSQL Database_ to ask __Server__ and __Database__
6. Enter connection info. Such as:
   127.0.0.1:9400
   npgsql_tests
7. Click __OK__ to proceed.
8. Another popup to query __Username__ and __Password__
9. Enter info such as:
   npgsql_tests
   npgsql_tests
10. Another popup _Encryption Support_ may be displayed.
11. Click __OK__ to proceed.
12. _Navigator_ popup will appear to select table.

Power BI Connectivity to PostgreSQL
https://community.dynamics.com/crm/b/microsoftdynamicscrmsolutions/archive/2015/12/02/power-bi-connectivity-to-postgresql

[darth-veitcher]

For those still coming across the issue you need to select the GAC option when installing the driver such that it gets exposed to Power BI.