Forum Discussion
Unable to connect to AWS RDS postgres via Cloud connection OR personal gateway
An update, I got it working using the enterprise gateway after resolving some firewall issues (also installing npgsql and certificates etc.), but it still didnt work via a direct cloud connection I guess because app.powerbi.com doesn't have a static IP, although I found a range of IPs that powerbi online uses but at present isn't feasible to whitelist all of them or even periodically keep it updated as and when MS updates it.
Thanks, yes I already checked that link earlier and its only about pbi desktop, which I am able to connect. Problem is from service.
Super UserHave you configured that exact thing in an EC2 VM with a Enterprise or Standard mode for the gateway? That thing in the post is what you need to do in the gateway vm too. After configuring, restart and try.
I hope that helps,
That part is in progress, although I dont have an EC2 VM, and I guess it shouldn't matter as the gateway can be on any machine right. But I do have a personal gateway on my pc and have configured all those things to try that myself before the changes in production gateway server, but the thing is I dont see the option to configure a connection via personal gateway as shown in my original post.
- ibarrau
You won't find it. personal mode doesn't work like that. We could say Personal mode is not the same gateway. It's kind of a different tool. It's a regular app. The standard is a windows service connected to power bi service in a better way. If you want to work with environments I still recommend standard gateway. Personal it's really just for one person to test stuff or specific requirements.
I hope that helps,
Ok I understand the limitations of personal gateway like its for one user, doesn't work with directquery etc. but I didnt find anywhere that it cannot connect to some databases or like in my case I dont see any specific reason of why I could not even use to test it before configuring the similar options on enterprise gateway server.