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...
gateway
POSTGRES
  • 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.



Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,lbendlin,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hello,rinogattuso .I am gald to help you.
I found the relevant issue link from my browser, hope it helps.
URL:

Power Query PostgreSQL connector - Power Query | Microsoft Learn

And I've noticed that some users try to use the ODBC connector instead of the PostgreSQL connector, but be aware that you'll need to reconfigure the data source and may need to modify the query.
URL:
Solved: Configure Gateway to connect to PostgreSQL - Microsoft Fabric Community
Solved: PostgreSQL connection through On-premise Data Gate... - Page 2 - Microsoft Fabric Community

If you need to use a gateway to connect to PostgreSQL, using ODBC is also a good idea.
Using ODBC is also a suggestion to try.
URL:
PowerBI and PostgreSQL : SSL, Let’s encrypt and Gateway


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