Currently only scheduled refreshes are possible. Please enable DirectQuery for Postgres in Enterprise and Personal Gateways so we can leverage Postgres db's running on Azure. Thank you.
This is a very useful feature request. As many huge companies are using PostgreSQL in their infrastructure, it should be possible.
