Forum Discussion

Shubh's avatar
Shubh
Frequent Visitor
8 years ago

On Premise Gateway Issue

Hey Everyone,   I am facing Timed out issue while refreshing my Dataset. I want to get some clearity regarding On Premise Gateway(personal and standard both).I have read documents regarding it, bu...
General Comment
Need Help
GilbertQ's avatar
GilbertQ
Super User
8 years ago
Hi there,

You can install it on your desktop that should be fine. As long as your desktop can access the data via the DSN.

With regards to the Azure Service bus, there is no need to worry about anything with regards to it, it is all automatically configured. Just imagine that it is not even there. There is no licensing or configuration required for the Azure Service bus.
Shubh's avatar
Shubh
Frequent Visitor
8 years ago

Hi,

 

So basically we dont need any access of Azure or Azure Service Bus.Just we need to install the gateway on any system which have the access of that database and 443 Port has to be opened for the same.

 

If i am wrong in any way, please correct me

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago
    That is 100% correct.
  • Shubh's avatar
    Shubh
    Frequent Visitor
    8 years ago

    Hi ,

     

    Thanks for ur time.

    I will check it again and if i have any more queries regarding it then will let u know.

     

    Thanks for the Help!!!

    Cheers Mate

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

    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.

  • Shubh's avatar
    Shubh
    Frequent Visitor
    8 years ago

    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??

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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!