cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fabiomanniti
Helper III
Helper III

PostgreSQL refresh with no gateway

Hello, I have my data on a PostreSQL and I'm connecting throug ODBC.

The problem is I must use a gateway to refresh my data.

Is there a way to use a connection between PowerBI and PostreSQL without using the gateway?

If I put my PostgreSQL on Azure, will I still need it?

I've read some threads about it but they're all few years old so I was hoping that the situation has been changed

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @fabiomanniti ,

 

It depends on what level of automation of refresh you want. Some options:

 

1) You can open your PBIX, refresh and republish if you want no automation.

2) You can set up a personal gateway on your own machine, or any other, if you want automation with no fail-over support and single-admin administration (you), but only when the chosen machine is on.

3) You can set up an enterprise gateway on multiple machines and 'cluster' them if you want automation with fail-over support and the ability for multiple admins to administer them, but only when the relevant machine(s) are on.

4) You can move your data to any platform within the Microsoft universe (anything based on sharePoint such as Teams, OneDrive for Business etc., or Azure etc.) for automation with no specific gateway, but at the loss of a certain level of control over the refresh process.

 

Pete

View solution in original post

4 REPLIES 4
BA_Pete
Super User
Super User

Hi @fabiomanniti ,

 

It depends on what level of automation of refresh you want. Some options:

 

1) You can open your PBIX, refresh and republish if you want no automation.

2) You can set up a personal gateway on your own machine, or any other, if you want automation with no fail-over support and single-admin administration (you), but only when the chosen machine is on.

3) You can set up an enterprise gateway on multiple machines and 'cluster' them if you want automation with fail-over support and the ability for multiple admins to administer them, but only when the relevant machine(s) are on.

4) You can move your data to any platform within the Microsoft universe (anything based on sharePoint such as Teams, OneDrive for Business etc., or Azure etc.) for automation with no specific gateway, but at the loss of a certain level of control over the refresh process.

 

Pete

Thank you @BA_Pete 

Well, what I want is

  1. Authomatic daily refresh
  2. No need of a gateway (any kind of gateway)

I need my DB to be in PostgreSQL and, at the moment, it's on Google Cloud Platform.

My question is: If I move my data on Azure

  • Can I keep a PostgreSQL datamart?
  • Is it possible to auto refresh my dataflows without gateway?

Because I want to know in advance before I start to move all my data to Azure and then I find out I still need the gateway

 

Thank you so much

@fabiomanniti ,

 

Re: your questions:

 

1) No idea if you can keep your datamart. Sounds like a very specialised question to me, which would probably need very specific research into your specific scenario.

 

2) Yes, within certain bounds. As before, Azure is within the Microsoft universe, so gateways not usually required. I suggest you check out the MS Docs entry about all this, as there's a whole lot more detail to be considered that can't reasonably be covered here.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data 

 

From the link above:

BA_Pete_0-1645092941594.png

 

Pete

I see, 

thank you

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors