Npgsql: Excel PowerQuery - 'Could not load file or assembly 'System.Memory, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified.'"

[isosphere]

Steps to reproduce

1. Be PowerQuery user
2. Have postgresql database (postgresql-11.2-1-windows-x64)
3. Go to this website that tells you to install npgsql https://support.office.com/en-us/article/connect-to-a-postgresql-database-power-query-bf941e52-066f-4911-a41f-2493c39e69e4
4. Install latest release (4.0.5) (used GAC install, maybe that's bad?)
5. Try to get data
6. Unable to connect, error pasted below

The issue

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.Memory, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified.'"

Further technical details

Npgsql version: 4.0.5
PostgreSQL version: postgresql-11.2-1-windows-x64
Operating system: windows 10

Other details about my project setup:

[fleetside72]

I have the exact same issue scenario that popped up after install 4.0.5 only difference being I am targeting postgres on linux vm.

[roji]

System.Memory is a new dependency that was indeed left out from the MSI installer... Have submitted a patch for this, which should be released with 4.0.6.

[isosphere]

Thank you @roji!

If anyone else is having the same problem, I've installed 4.0.3 instead which appears to be prior to this dependency. The older version seems to be working fine for me.

[hoegge]

Same here with newest 4.1.1. with 4.0.3 and 4.0.0 and another similar error with 3.2.7