Forum Discussion
On Premise Gateway Issue
Here is the reference for the required ports to be open.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem#ports
Also, make sure your gateway is installed in the same region that your data is being hosted. I had a gateway that was trying to refresh data from another country around the world in a database server. I was seeing the same kind of issue. This was causing issue in my environment. I acutally hosted the database in a local server rather accross the world.
Hi Anonymous
As i have installed the gateway on my system and while me fetching data through sql via ODBC, so do i have to open required port for my system and server(where me fetching data) or just my system only??
And can tell me "make sure your gateway is installed in the same region that your data is being hosted" about this more.
I am from india and choosen region as south asia..will that work??
Hi Shubh
Your gateway server is the sytem that requires the ports open. Typically you will see issues with connectivity if your ports are not open correctly from your gateway.
For the issue I have notice with performance was noticed with the following setup, having an on-prem gateway in the US and then our Power BI teant is in South East Asia. When I setup a gateway connection in my US gateway server to refresh data in a Japan SQL server the data wasn't refreshing. I decided to move to sql data to a US server hosted in the same environment as the gateway. It appears the gateway server needs to be near or within the same region as your data.
https://azure.microsoft.com/en-us/regions/
https://azure.microsoft.com/en-us/regions/services/
You can find service bus under Enterprise Integration. I think this is the connection to the Power BI Gateway server. Hope this helps!