Doesn't Npgsql also require the gateway?
From the HEVO link: PostgreSQL To Power BI: 3 Best Ways To Connect - Learn | Hevo (hevodata.com)
https://hevodata.com/learn/connect-postgresql-to-power-bi/#c
Through The Configuration Of PostgreSQL And Power BI In order to connect PostgreSQL to Power BI, you need to configure both of them.
Configuring PostgreSQL You need to first edit the pg_hba.conf file : sudo nano path/to/your/file/pg_hba.conf
You need to allow remote connections from a host and allow it to all databases. All PostgreSQL users will be allowed and connections from anywhere around the world will be allowed. You can, of course, edit it according to your own requirements limiting the databases and range of your networks.
This is what your pg_hba.conf file should look like: Now you have to edit your postgresql.conf file.
You have to change the line ssl = true to ssl = false. Power BI by default only trusts applications that have the SSL certificate. To get the certificate, you need to change the SSL settings.
You can avoid all of that by simply disabling SSL. sudo nano path/of/your/file/postgresql.conf ssl = false
Next, you need to restart PostgreSQL in order to let it know about the changes. You can restart from the command line using this command: sudo service postgresql restart Configure Power BI Open Power BI Desktop. Click on ‘Get data’ and choose the option ‘More’.
(Also both of the links you supplied are also in my original post (just saving clicks for any future readers... I apprecaite the try!))
