Forum Discussion
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.
powerbiexpert22 Start by creating a new report and selecting a blank report template. Next, add your data sources. For AWS Aurora PostgreSQL, go to the "Data Sources" pane, right-click, and select "Add Data Source." Name your data source, select "Use a connection embedded in my report," choose "PostgreSQL" as the connection type, and configure the connection string with the necessary details like server name, database name, user name, and password. Test the connection to ensure it is working. Similarly, for External ODBC MS SQL, add a new data source, select "ODBC" as the connection type, and configure the connection string with the DSN, user name, and password. For Excel/CSV, add a new data source, choose "Microsoft Excel" or "CSV" as the connection type, and browse to locate your file. Test all connections to ensure they are working properly.