Forum Discussion
gateway can solved firewall error?
Hi all, I want to get data from server that protected with firewall, i can get data from BI desktop, but in BI service - i get status code 400, the error come from firewall, i tried to add range of IP's to the firewall allowslist but with no success.
Is there another option that i wil lbe able to refresh from the Service too? maybe install on the data source Gateway?
Thank you.
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
12 Replies
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.
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.
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
