How to enable SSL for Cloud PostgreSQL connection from PowerBI service

Hi, v-easonf-msft 

Thanks for the links you shared. It is similar to other contents I found before posting.

Unfortunately, they do not provide a satisfactory answer:

• a lot of content is deprecated, referring to npgsql being required even for PostgreSQL for PowerBI Desktop, while it is working now perfectly without requiring any additional component.
• if the gateway is mandatory, why then is the service actually trying to connect to the specified SQL server database, albeit without any secure connection? The simple fact that there are settings to configure the connection in PowerBI Service suggests that this should be supported. How should I proceed to submit this as a bug report ?
• at least one of them mentions using the gateway to access Azure hosted databases. This seems wrong, as it would mean having to go from PowerBI Service hosted by Microsoft to an Azure database hosted by Microsoft through an on-premise middleware ?! How would that work with a full Azure setup with absolutely no on-premise infrastructure ? Would it require having to pay for an additional Azure Windows VM just to host the gateway ?
• is there an official list of currently supported data source for the different modes (PowerBI Desktop, PowerBI Service) ?
• is Microsoft using the wording "cloud" datasources only for Azure datasources ? Cloud is usually used to refer to services that aren't on-premises, that is to say hosted on a private infrastructure not available from outside that private network.

Furthermore, I'd be really interested in how third party cloud services connector work, such as the one for Salesforce, which are hosting their date on their Salesforce cloud.

Best regards,