Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Gateway Cluster issue

Hi,

 

I had one gateway installed on a windows server with data sources configured.

I installed one more gateway on another physical machine and added to existing gateway. But when I am disabling first gateway, reports are not getting refreshed with second gateway. It's giving error. Also, if I checlk this option "Distribute requests across all active gateways in the cluster", report is not getting refreshed, it's giving error. Please assist.Thanks.

.

Need Help

8 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Seems like you maybe do not have a certain driver or something installed on the gateway required by a data source. Maybe an ODBC connection?

     

    You could check the Issues forum here:

    https://community.powerbi.com/t5/Issues/idb-p/Issues

    And if it is not there, then you could post it.

    If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    The gateway must be online when you refresh, for one machine you can only run 1 enterprise gateway at a time. Try login and run the two gateways on difference machines, usually you can connect to the datasources on any machine within your company.

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for you reply.

      Yes, Gateways are online. Both Gateways working fine on individual machine. But when adding 2nd Gateway in cluster, reports are

      not getting refreshed from 2nd Gateway (after disabling 1st Gateway).Drivers are installed.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Anonymous 
        Sorry I didn't get your problem correctly. So what do you mean by disable the first gateway? Remove it from the cluster?

         

        In order to let the report refresh through the 2nd gateway, you need to go to Setting => Dateset, select the dataset of the reports to re-configure the gateway connection, usually you can map to the 2nd gateway.

         

        Paul Zheng _ Community Support Team
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • m-colbert's avatar
    m-colbert
    Resolver III
    4 years ago

    I would agree with Greg_Deckler. What is this datasource that is causing the error?  Ihad a similar problem when setting up a new cluster and one of the machines was missing a HANA ODBC driver. 

    Disabling other cluster memebers and testing refreshes is a perfectly acceptable method for making sure the cluster is wokring properly. 

    Hope this helps.