Forum Discussion
Post ProdigyAWS PostgreSQL Schema and PBI Gateway & Dev options (Not using EC2)
Hi, icassiem
You mentioned removing the connection and release gateway from Power BI Desktop to AWS PostgreSQL. You need to make your PostgreSQL accessible to Power BI, for example by releasing specific ports. Make sure the PostgreSQL instance is configured to accept connections from outside the VPC. Then use the PostgreSQL database database in Power BI desktop.
You mentioned migrating AWS RDS PostgreSQL offline to Azure Database for PostgreSQL, you can refer to the official documentation below:
If you want to migrate to an Azure virtual gateway, you may need to create a virtual gateway in Azure, which you then use in Power BI Service to create a data connection.
Tutorial – Create & manage a VPN gateway – Azure portal - Azure VPN Gateway | Microsoft Learn
I hope the above stuff will help you.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, icassiem
You mentioned removing the connection and release gateway from Power BI Desktop to AWS PostgreSQL. You need to make your PostgreSQL accessible to Power BI, for example by releasing specific ports. Make sure the PostgreSQL instance is configured to accept connections from outside the VPC. Then use the PostgreSQL database database in Power BI desktop.
You mentioned migrating AWS RDS PostgreSQL offline to Azure Database for PostgreSQL, you can refer to the official documentation below:
If you want to migrate to an Azure virtual gateway, you may need to create a virtual gateway in Azure, which you then use in Power BI Service to create a data connection.
Tutorial – Create & manage a VPN gateway – Azure portal - Azure VPN Gateway | Microsoft Learn
I hope the above stuff will help you.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post ProdigyThank You Anonymous
The PostgreSQL option is our primary focus, if the PostgreSQL instance is configured to accept connections from outside the VPC, how would the PBI service connect to the postgresql?
would it not require a pbi gateway or would i need to setyp a pbi service gateway directly to PostgreSQL?
Hi, icassiem
Thank you for your reply. You can connect to your PostgreSQL in Power BI Service in two ways. The first one is to connect by using Power BI enterprise gateway, and the second one is to connect by cloud. You can try both connection methods.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- icassiem
Anonymous wow, Thank You so much 🙏
I will be giving it a try in the next 2 weeks as we start implementing
Hi, icassiem
Did my previous answer solve your current problem? If so, you can mark it as a workaround so that other members of the community can quickly find an answer if they have a similar question. If you have a new question in the future, you can post it in a new post so that more people will see it so that more community members can help you solve the problem.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.