Forum Discussion
Data source(postgres) connectivity with powerbi gateway
We are trying to connect with postgres sql which is hosted at cantos machine on premise server. On windows machine we have installed the power bi gateway and where database is accessable. This error is been coming from app.powerbi.com. Please help us.
Underlying error message: Please install Npgsql version 4.0.10.0 or earlier.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: PostgreSQL
14 Replies
Which Npgsql version is installed on the gateway?
Hi Anonymous ,
Based on your description, it may be that the version you are currently using cannot match Power BI Service. You can try to install the previous version and then connect to the data source.
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i am also facing same issue, whereas i am using single gateway for SQL & PG, SQL Reports are working fine, but PG Connection is not working with same error.
There is a bug in the gateway installers. It is missing the npgsql ADO drivers. Copy them over from the Desktop install.
I have already installed npsql3.2.6 but it's showing same error
