Correct — the standard Postgres connector is for Desktop. For Power BI Service, you'll need an On-Premises Gateway to connect to your Heroku Postgres database.
If you want to skip the Gateway, you'd need to replicate your database to Azure, but that's more complex.
Using the Gateway is the most practical solution for most setups.