Forum Discussion
gateway can solved firewall error?
- 4 years ago
Yes on-premises gateway will mak it more stable and may help you in speed up processing too.
You can install your enterprise gateway on the same server as the datasource but keep a note on the ports that are required to be opened on the server to make the gateway work as it needs to communicate outside. If your report is already published in a workspace you don't have to do anything, just create a gateway and register it then you will see an option to ocnnect your datasource to gateway and just add it there.
You can find more details here:
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-communication
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-indepth
Hi Mornagli
Please install enterprise gateway on a server which has got connectivity to this server and then you will be able to refresh your reporting by creating datasource on gateway.
- Mornagli4 years agoHelper III
Hi nitishsh91 thank you, form my understaning we have our server that store the data , and from PBI i send requests to the server, so i didnt understand excatly what did you mean with the
"enterprise gateway on a server which has got connectivity to" , is it another server that i need to use or can i instal this gateway on the server the store our data?
Thank you.
- nitishsh914 years agoSolution Supplier
For connecting to any on-premises datasource which is protected by firewall, we use enterprise gateway which creates a channel between on-premises data source and powerbi and helps in auto refresh of reports.
This link will help you in better understanding:
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem
- Mornagli4 years agoHelper III
Thak you nitishsh91 , and if i get my data with an ODATA connector, in the service im not required for gateway but the refresh in the service is unstable (sometimes takes too long, return timeout after two hours, and sometimes take couple of minutes and succeed), if i will install gateway in my data source will it make the connection better? and if so, do i work in the MPBI Desktop as i worked before the gateway or i will be needed to get the data in a different way ?
Thnak you.