Forum Discussion

Copycat's avatar
Copycat
Frequent Visitor
2 years ago
Solved

PowerBI gateway / postgresql / npgsql error 400

Good day,   please bear with me on this once, since I have no previous knowledge about PBI gateways but I was assigned to a project where I'm supposed to maintain one.   Our Client asked us to in...
gateway
npgslq
PostgreSQL
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Copycat ,

    Regarding the error 400 your client encountered while attempting to connect to a PostgreSQL database via the Power BI Gateway, this error typically indicates a "Bad Request." It can occur due to various reasons, including invalid syntax in the request or authentication issues.

    Confirm the authentication method required by the supplier's PostgreSQL database. If OAuth is indeed required, you'll need to set up OAuth credentials instead of using basic authentication.

     

    More details: Power Query PostgreSQL connector - Power Query | Microsoft Learn

     

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with the error.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Copycat ,

Regarding the error 400 your client encountered while attempting to connect to a PostgreSQL database via the Power BI Gateway, this error typically indicates a "Bad Request." It can occur due to various reasons, including invalid syntax in the request or authentication issues.

Confirm the authentication method required by the supplier's PostgreSQL database. If OAuth is indeed required, you'll need to set up OAuth credentials instead of using basic authentication.

 

More details: Power Query PostgreSQL connector - Power Query | Microsoft Learn

 

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with the error.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.