Forum Discussion
configure PostgreSQL database for power bi service
To disable the encrypted connection you need to access the data source settings in Power BI Desktop, and edit the permissions for your postgresql data source. There is an option labeled "Encrypt Connection" which you can deselect.
You can find the option by expanding the arrow under transform data, or in your file > options and settings > data source settings.
If your Postgresql is hosted online, and not on a local network, then you shouldn't need a gateway in order to refresh the data. I'm not familiar with the specifics of using Postgresql in PowerBI so that's more of a logical guess than an confirmation.
Helper ITo disable the encrypted connection you need to access the data source settings in Power BI Desktop, and edit the permissions for your postgresql data source. There is an option labeled "Encrypt Connection" which you can deselect.
You can find the option by expanding the arrow under transform data, or in your file > options and settings > data source settings.
If your Postgresql is hosted online, and not on a local network, then you shouldn't need a gateway in order to refresh the data. I'm not familiar with the specifics of using Postgresql in PowerBI so that's more of a logical guess than an confirmation.