How to Connect Power BI to Aiven PostgreSQL Using ODBC (Step-by-Step Guide)

Introduction I tried connecting Power BI directly to a PostgreSQL database on Aiven and run into this frustrating error: The remote certificate is invalid according to the validation procedure I fixed it and this article explains the steps I took to connect to my postgre database: I used ODBC (Open Database Connectivity) This is the step by step process on how I did it: Install the PostgreSQL ODBC driver Configure a secure connection - with SSL Connect Power BI to your Aiven PostgreSQL database