Forum Discussion

JuliaYebra's avatar
JuliaYebra
Helper III
8 years ago

Scheduled refresh not allowed when using Merge/Append functionality

I have a report that has two datasources:

 

- SAP BW

- Sharepoint online list

 

If I publish the report and scheduled a refresh, it works great.

But I use a merge or an append between them, the option is not available anymore and instead the following message appears:

 

You have no gateway installed or configured for the data sources in this dataset. Install a new data gateway or configure the data source for an existing data gateway.

 

Do you have this problem???

Need Help

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi JuliaYebra,

     

    As error message pointed out, please try to add both data sources to gateway and test again.

     

    Regards,

    Yuliana Gu

    • JuliaYebra's avatar
      JuliaYebra
      Helper III
      8 years ago

      v-yulgu-msft

       

      The sharepoint online list doesn't need a Gateway.

       

      Also, the scheduled refresh works well with the 2 sources at the same report when you have them separated. 

      The problem appears when you use a merge or an append combination. At that point, the BW gateway can't be selected anymore.