Integration CloudPostgreSQL to PowerBi.

[Sujit Ramugade]

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?

[Peter Kok]

Hi Sujit,

Since you're a bit sparse on your environment in which you use PowerBI, it's hard to answer, but I would suggest looking into running Cloud SQL Auth Proxy locally (on server or network) to your PowerBI environment. 

https://cloud.google.com/sql/docs/postgres/sql-proxy

Thx

Peter

--
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-d...@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.

[Scott Ertel]

Hello, 

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.r...@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?

--

[Sujit Ramugade]

Thanks, @bala @peter @scott I will try to implement my setup with the above suggestions.
Thanks for the inputs :-) will ping here if required more clarification

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/D5F4D41E-B3EA-4EB7-A968-DB2E6A4E570C%40gmail.com.

--

Sujit Ramugade CloudOps - DBA M:+91-7387107873 www.searce.com solving for better

 

The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. Searce is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.