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
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