Sharepoint Scheduled Refresh Error

Hi Anonymous 

You accesse on-premises (SQL Server database) and cloud sources (Sharepoint.) in the same source query

Please check whether you do merging or appending data from on-premises and cloud sources.

If you do, you need to do two options as below to configure a data gateway to support merging or appending data from on-premises and cloud sources:

• Add a data source definition for the cloud source to the data gateway in addition to the on-premises data sources.
• Enable the checkbox Allow user's cloud data sources to refresh through this gateway cluster.

You can refer to this blog for more details: Refresh Data

And I found an issue like yours, I hope it could help you.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.