Forum Discussion

MunTah's avatar
MunTah
Frequent Visitor
2 years ago
Solved

Two gateways in one report

Hello,

 

 

I'm facing a challenge with my gateways where I have a report which uses A. SQL on premise B. PostGreSQL. As soon as I try to set a automated refresh on my report, I get an error message. I assume that I can't use two different gateways and each and every one is connect to a specific database. How can I create a cluster which combines 1. Gateway for SQL 2. Gateway towards postgresql 

 

 

is it even possible to do that? What are the other solutions which you recommend to overcome this?

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    There is a limitation but it doesn't seem to be applicable to your scenario.  The limitation is that "All on-premise data sources in your semantic model must be served by the same gateway".  You can work around that limitation by using dataflows for some of your data sources.

     

    Anyway, your scenario seems to be different.  Please describe again what your setup is, which data sources are on-premise and which are cloud based.

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    There is a limitation but it doesn't seem to be applicable to your scenario.  The limitation is that "All on-premise data sources in your semantic model must be served by the same gateway".  You can work around that limitation by using dataflows for some of your data sources.

     

    Anyway, your scenario seems to be different.  Please describe again what your setup is, which data sources are on-premise and which are cloud based.

    • MunTah's avatar
      MunTah
      Frequent Visitor
      2 years ago

      Appreciate the answer. 

       

      The PostgreSQL is on the cloud and the other data source is on-premise. I have in total two gateways, one is for the PostgreSQL and the other one is for on-premise. 
      My raport has to use both data sources. 

       

      The work around though dataflow sounds undoubtably doable and I might just have to give up the cluster solution which might give me the possibility to combine those two different gateways?

      • SaiTejaTalasila's avatar
        SaiTejaTalasila
        Super User
        2 years ago

        Hi MunTah ,

         

        You can create the connections on same gateway cluster.Why you need to keep them two gateways?

         

        Thanks,

        Sai Teja 

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    Super User
    2 years ago

    Hi lbendlin ,

     

    You can go with a dataflow.Import your tables to a dataflow and consume/import data from dataflow to reports.

     

    Thanks,

    Sai Teja