Forum Discussion
Postgres error with Power BI Desktop
I have a PostGRES DB I'm trying to connect to using ODBC as it has a port and SSL requirement that seem to mean the postGRES conenctor will not work.
Error mesasge here:
Details: "PostgreSQL: We were unable to find a database provider with invariant name 'Npgsql'.
This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'Npgsql version 2.0.12': https://go.microsoft.com/fwlink/?LinkID=282716"
I have the PostgreSQL35W driver installed (according to my ODBC) byt Power BI keeps erroring wehn I try to use it saying the Driver is not installed.
NB: I am using Windows 10x64 as my client for the Power BI desktop install.
I'm trying connections stringsd as found at
https://connectionstrings.com/postgresql-odbc-driver-psqlodbc/
but keep gettgin told I don't have the postgreSQL Unicode driver installed.
1 Reply
Hi,
I followed exactly this tutorial
http://outofmemory.azurewebsites.net/configure-npgsql-on-windows/
and I could make it work. Pay attention to the exact version of Npgsql you write in the DbProviderFactories tag. Check your GAC content and pick the exact version out of it.
Hope it helps!
