Connecting to Postgres using Power Bi Inbuilt connector

[georgehalford22]

I am getting the following error: 

An error happened while reading data from the provider: 'The requested name is valid, but no data of the requested type was found'"

Please advise?

[v-yuezhe-msft]

@georgehalford22,

What version of Npgsql do you install? Are you able to connect to the PostgreSQL in PostgreSQL client or other applications such as Excel?

In my environment, I installed Npgsql 3.1.8 and there is no issue when I connect to PostgreSQL in 32 bit Power BI Desktop(2.50.4859.782).

Regards,
Lydia