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
Shubh's avatar
Shubh
Frequent Visitor
8 years ago

Hi GilbertQ

 

Thanks for your response.

 

I am using an ODBC Connection. But haven't configured any Azure Service Bus for it.

 

Can you please tell me the procedure and license cost for the same??

My data get refreshed on Power BI  Desktop in 30-40 seconds by manual refresh

But on cloud(Power BI Services), it not refreshing neither by manual refresh nor by schedule refresh.

 

Though my gateway and Data Source credentials are successful.

 

  • Shubh's avatar
    Shubh
    Frequent Visitor
    8 years ago

    Hi GilbertQ

     

    I am getting a successful connection when i added data source to my gateway.

    It is not showing any error in connection.

    But when i refresh the dataset, it always show timeout error as it takes more than 2 hrs.

    While refreshing it with Power BI Desktop, it get refreshed within 30-40 seconds.

     

    And can you please tell me how to configure Azure Service Bus because presently i am not using this bus in anyway.

     

    I have just added Data source to my gateway and connection for the same is successful.

    • GilbertQ's avatar
      GilbertQ
      Super User
      8 years ago
      Hi there, the Azure Service bus is controlled by the On-Premise Data Gateway. There is nothing for you to configure.

      What I would suggest is to enable the logging on the On-Premise Data Gateway on your server to see why it is taking so long.

      Also see if there are any issues on your server whilst the refresh is happening? Maybe the DSN needs a fully qualified name in order to find your ODBC source.
      • Shubh's avatar
        Shubh
        Frequent Visitor
        8 years ago

        Hi GilbertQ

         

        I have install the gateway on my Desktop as i want to first check its working and configure with my organisation id as only i have the access to that Database from where i am fetching the data. Do i have to install gateway on server?

         

        Do i need any Azure license for running Azure Service Bus???