An option you could look at is creating a windows VM in google cloud and install the enterprise gateway connector on it. Then you would need to install the Postgres connector on that machine. This will allow the powerBI service to reach the database.
I'm assuming connectivity is already in place and users can already connect to the database in your internal network.
Sent from my iPhone
On Mar 15, 2022, at 2:26 AM, Sujit Ramugade <sujit.ramugade@searce.com> wrote:
Hi Team,We have a requirement to connect Cloud PostgreSQL w/ PowerBI for reporting needs. Could you please suggest what is the best possible solution here?--
Since there is no direct/easy connectivity - team is taking the reporting data out of cloud (postgre) sql --> moving it to SQL express --> connecting with PowerBI. Is there any better solution?
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f25bee9e-bb48-46cf-b166-d499985b065bn%40googlegroups.com.
No comments:
Post a Comment