Power BI now supports direct query for Azure Database for PostgreSQL, both single server and Hyperscale (Citus). With direct query support, data isn’t copied or pulled directly into Power BI, instead queries are pushed down to the database engine and results retrieved.
Source: Azure Roadmap