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, rather queries are pushed down to the database engine and results retrieved. This provides faster and larger scale reporting for your Azure Database for PostgreSQL databases.
For more information, see the article Use DirectQuery in Power BI Desktop.
Read the article Use DirectQuery in Power BI Desktop
Learn more about Azure Database for PostgreSQL