The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
42 | |
29 | |
26 | |
23 |