Forum Discussion

LinhNguyen's avatar
LinhNguyen
Helper II
6 years ago
Solved

Connect to multiple sources while using enterprise gateway

Hello,

 

I have an enterprise gateway that can connect to SAP BW and I have tested it by creating a data set with just that one connection.

 

However, I need to useSAP BW together with some powerBI dataflow and atfer I added the dataflows in, the enterprise connection was not shown in Schedule Refresh anymore.

 

What could I have done wrong?

 

Thank you,

  • nickyvv's avatar
    nickyvv
    6 years ago

    Hi LinhNguyen, thanks for clarifying.

    For the Web Page connector in a dataflow, you do need a gateway, as the UI suggests:

3 Replies

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional

    Hi LinhNguyen, that mostly happens when one of the sources in your datamodel (in this case obviously the dataflow) is not a gateway entry. Could you check that the exact source is in your gateway, and you have access to it?

    • LinhNguyen's avatar
      LinhNguyen
      Helper II

      Hi nickyvv ,

       

      I assumed at first that we didn't need the PowerBI dataflow in our gateway because it's a web data source and if the dataflow is the only datasource, I would normally not even need to set up a gateway.

      Do we need to add all of our dataflows into the data gateway?

       

      Thanks,

      • nickyvv's avatar
        nickyvv
        Most Valuable Professional

        Hi LinhNguyen, thanks for clarifying.

        For the Web Page connector in a dataflow, you do need a gateway, as the UI suggests: