Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When trying to schedule a dataset through a personal GW - the PostgreSQL datasource throws error when I enter the credentials:
"Failed to update data source credentials: An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"
The enterprise gateway is working OK, the problem is in the personal gateway...
Please help
Thank you
Michael
An update - the refresh is working with ODBC and Personal Gateway
So it is something with PostgreSQL connector, maybe npgsql driver?
But the connector is working when I run Desktop.
So the problem is just in the combination of Personal GW & Connector
I will open a ticket, but first maybe someone is experiencing this too?
Thanks!
I agree, but my Enterprise Gateway is currently being used and played with outher team so I cannot rely on it.
I still expect my Personal Gateway to work...
How do I solve the problem?
Thanks
Hi @michaelshparber ,
Please check if the solution in the following thread can solve your problem.
Best Regards
Rena
The solution there was to change postgreSQL connector to ODBC
I want to do it with postgreSQL connector.
And my credentials are OK - everything works in the Enterprise GW.
Also the Personal is working ok with SQL Server
So something is not OK in the service with mixture of (personal GW + postgreSQL)...
Please help
Thank you!
Hi @michaelshparber ,
If the verison of personal gateway and Npgsql is latest?
https://go.microsoft.com/fwlink/?LinkId=820925&clcid=0x409
https://github.com/npgsql/Npgsql/releases
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
Best Regards
Rena
@GilbertQ Sure Gilbert, I have already wrote that above:
Another team is playing around the Enterprise Gateway now - they are resseting it, uninstalling etc.
I cannot rely on it.
I need the Personal Mode - it should work, too...
Somebody, please help!
I cannot have 2 Enterprise GateWays simultaneously...
Enterprise GW is not relevant.
I am looking for a Personal GW solution. It should work...
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.