Forum Discussion
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...
Hi JuliaYebra,
As error message pointed out, please try to add both data sources to gateway and test again.
Regards,
Yuliana Gu
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.