Report Builder - multiple data sources

Hi powerbiexpert22,
Thank you for the follow-up question.

You are correct. Amazon Aurora PostgreSQL is a cloud data source, and in most scenarios, it can connect directly without a gateway if it is publicly accessible or uses a cloud connector.

However, since in your case there are security restrictions (for example, private network, VPC, firewall rules) and the Aurora instance is not directly accessible from the Power BI Service, you can still use the same on-premises data gateway you have already set up for MSSQL and Excel.

The gateway just needs network connectivity to your Aurora PostgreSQL instance (e.g., via a VPN or private link). Install the correct 64-bit ODBC or Npgsql driver for PostgreSQL on the gateway machine. In the Power BI Service, create a new data source connection under that same gateway for Aurora PostgreSQL.

So, no separate gateway installation is needed one standard mode gateway can manage all three: MSSQL, Excel/CSV, and Aurora PostgreSQL, as long as it is configured with the right drivers and network access.

Refer these link:
Power Query PostgreSQL connector - Power Query | Microsoft Learn
What is an on-premises data gateway? | Microsoft Learn

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.