Forum Discussion
Error connecting Postgres with Gateway
- Anonymous1 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 17There 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.
Gateway install files do not include the Postgres drivers. You can borrow them from the Desktop install.
From C:\Program Files\Microsoft Power BI Desktop\bin\ADO.NET Providers
to C:\Program Files\On-premises data gateway\m\ADO.NET Providers
everything npgsql