connection to power bi

[scobbyy2k3]

I get this message each time i try to connect to postgres to power bi, how do i solve it.

Thanks

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

Before submitting

This repo is for Npgsql ADO.NET issues only. Entity Framework issues belong in Npgsql.EntityFrameworkCore.PostgreSQL for EF Core, or EntityFramework6.Npgsql for EF 6.x.

Steps to reproduce

Ideally include a complete code listing that we can run to reproduce the issue.
Alternatively, you can provide a project/solution that we can run.

The issue

Describe what is not working as expected.

If you are seeing an exception, include the full exceptions details (message and stack trace).

Exception message:
Stack trace:

Further technical details

Npgsql version:
PostgreSQL version:
Operating system:

Other details about my project setup:

[suttontools]

Same/Similar 'Unable to connect' pop up window here:
The application is Power BI Desktop. Npgsql was installed using the *.msi installer: https://github.com/npgsql/npgsql/releases/download/v4.1.1/Npgsql-4.1.1.msi

DB is on AWS

[scobbyy2k3]

i already installed it, but still getting the same error

…

On Mon, Oct 21, 2019 at 1:38 AM Dowster ***@***.***> wrote: Same/Similar 'Unable to connect' pop up window here: The application is Power BI Desktop. Npgsql was installed using the *.msi installer: https://github.com/npgsql/npgsql/releases/download/v4.1.1/Npgsql-4.1.1.msi DB is on AWS — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#2701?email_source=notifications&email_token=AL5NELKWUTSQ5GJZAQO7VXTQPU56NA5CNFSM4JCTTY6KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEBZDRQA#issuecomment-544356544>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AL5NELN32JZ64NZQYF3AXKDQPU56NANCNFSM4JCTTY6A> .

[kristofTGITM]

same issue, worked with 4.0.10. But no longer with 4.1. Uninstalled, reinstalled 4.0.10. works again.
FYI: tested on multiple computers, multiple rights (local admin vs normal user) multiple PBI installations (via MSI or via Dekstop App) all failed. roll back did the trick for now.
EDIT: No tableau installed.

[dford07]

might not be relevant to you but i had the same problem because i had Tableau installed and it was hijacking the postgres odbc driver..
i nuked Tableau but it didnt clean up the registry.

in the registry you want
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL\pgxalib.dll
to point to c:\WINDOWS\system32\pgxalib.dll

you may need to delete that key in the registry and reinstall the postgres ODBC driver..

worth a shot for you

[scobbyy2k3]

I also have tableau installed .. that might be the problem . How do I get into the registry to have it fixed ?

[dford07]

1. run -> regedit
2. delete the following key Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL\pgxalib.dll
3. install the postgres ODBC driver
4. connect with powerbi

That worked for me

[scobbyy2k3]

Am I deleting the whole path from hkey or I have to go into the path until
I get to xadll .

[dford07]

go into that registry path, delete the entry for pgxalib.dll
then reinstall the postgres odbc driver

[josearacil]

same issue, worked with 4.0.10. But no longer with 4.1. Uninstalled, reinstalled 4.0.10. works again.

Going back to 4.0.10 works fine for me as well.

[muthugit]

Yes it works with Ngpsql 4.0.10 version
https://github.com/npgsql/npgsql/releases/tag/v4.0.10

[k1pacho]

works with Ngpsql 4.0.10 (GAC), 4.1 failed,
Power BI Version: 2.74.5619.862 64-bit (desktop, Oct2019)
PostgreSQL 9.6
no Tableau

[roji]

Duplicate of #2677