Forum Discussion
Scheduled update with Postgresql source
You don't need a gateway if the Power BI Service can see your data source directly. (For example if your PostGres database is exposed to the interwebs). In all other cases you do need a gateway, and the gateway needs to be able to see your data source directly. That means, yes, the gateway needs to be created in the same Google Cloud environment as your database. Note that gateways run preferably on WS2019 VMs.
In this case is therefore the gateway is not necessary.
However, when editing the credentials I always get the error:
-Data source credentials: When I edit the credentials and enter the username and password I get the following error:
Data source credentials could not be updated: 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'
Do you know how to solve this?
