Forum Discussion

rinogattuso's avatar
rinogattuso
New Member
1 year ago
Solved

Error connecting Postgres with Gateway

I can connect Power BI Desktop to a local Postgres server, so I published a Power BI report and tried to set up a connection on Power BI Cloud with my local gateway that can access Postgres. If I tr...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi,rinogattuso .Merry Christmas to you.
    I subsequently configured the relevant pbix reports according to the official documentation and successfully completed the refresh operation on Service
    I hope you find the following test helpful.

    My
    servername:
    localhost:5432
    


    I use the version :PostgreSQL 17

     

    There was a problem at the beginning.

    Requires version 4.0.10 or earlier (do not download newer versions)

    Release Npgsql v4.0.10 · npgsql/npgsql · GitHub

    Note that you must check the box for

    After successful installation restart the computer (you have to restart the computer)

    Log in to the power bi service and configure the on process gateway.

    When the gateway is set up correctly, the data source credentials issue is automatically resolved as well
    PostgreSQL Refresh Successful.

     


    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.