Setting up Power BI to schedule publishing from PostgreSQL
You should be able to do this using the Power BI On-premises data gateway.  You'll need to install it on a Windows computer, along with the Postgres ODBC driver, but it shouldn't have any problem talking with your Postgres install on Linux.