Scheduled refresh not allowed when using Merge/Append functionality

[JuliaYebra]

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???

[v-yulgu-msft]

Hi @JuliaYebra,

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

Regards,

Yuliana Gu

[JuliaYebra]

@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.