Forum Discussion

georgehalford22's avatar
georgehalford22
Frequent Visitor
8 years ago

Connecting to Postgres using Power Bi Inbuilt connector

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?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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