Forum Discussion

JuliaYebra's avatar
JuliaYebra
Icon for Helper III rankHelper 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...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft 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
Icon for Helper III rankHelper 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.