Power BI Gateway Refresh error for Sharepoint List

Hi GeorgeAivazidis ,

You accesse on-premises (OData) and cloud sources (Sharepoint,OneDrive ) 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.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien