Forum Discussion
Gateway / Dataset
If you can access postgres database from the machine on which on-premise gateway is setup then only it will work and ideally both should be in same network for it to work.
Excel can be hosted online on sharepoint and that will remove dependence on gateway and it can be accessed directly.
Hi BigBadBob
You can have all excel files on sharepoint so that you don't have to rely on gateway to refresh reports, it will work directly online and for database you can use on-premises gateway.
Hi. Thank you for the response.
The issue is that the database (postgres) is accessed by the client via a web browser and is hosted offsite (by the external IT provider)
Power BI gateway has been setup on virtual machine by the IT provider as it is not on premises which i thought would be the only solution. Please tell me if you disagree. I could be wrong but i can not see how they could connect to the database on premises when it is offsite and only accessed via a web terminal
Then to include excel it needs to either be added to the gateway somehow and is not accessible by the client
Very confusing!
Thanks again
If you can access postgres database from the machine on which on-premise gateway is setup then only it will work and ideally both should be in same network for it to work.
Excel can be hosted online on sharepoint and that will remove dependence on gateway and it can be accessed directly.