Forum Discussion

mkp88's avatar
mkp88
Regular Visitor
10 months ago
Solved

Unable to connect to AWS RDS postgres via Cloud connection OR personal gateway

I want to setup refresh for reports using AWS RDS postgresdb and after following some steps (re. aws certificate, npgsql etc.) I was able to connect to it from desktop but when I publish it in servic...
Need Help
  • mkp88's avatar
    mkp88
    10 months ago

    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.

mkp88's avatar
mkp88
Regular Visitor
10 months ago

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.