I have a postgresql database as a linked service in Google Cloud and I use this database as a source for the development of a dashboard and publish it in power bi service.
However, when I try to schedule an update I can't do it and I don't understand why:
In the semantic model options I have:
-Gateway and cloud connections: You don't need a gateway for this semantic model, as all your data sources are in the cloud, but you can use a gateway to improve control over how to connect.
-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'
Does anyone know how to solve this?
On the other hand, I have tried to create an odbc data connection and in this case it does ask me to set up a gateway, however, what should this gateway be like? Should it be installed in a Google Cloud virtual machine? I need it to be always operative, so I could not install it locally.
Thank you
