Forum Discussion
PostgreSQL refresh with no gateway
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
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:
Pete
I see,
thank you