Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Please can you help with the below as i am stuck...
Scenario:
Issue:
Solution:
Please can you suggest setup solutions for gateways etc for where the business has no on premises server
Thanks all!
Solved! Go to Solution.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.