Unable to create a Data Source Type for SharePoint in a Gateway Cluster.

Hello everyone,

I have a Power BI Report which is extracting a portion of data from our On-premise MS SQL Database and a portion from SharePoint (specifically a Folder on SharePoint Online Site with about 15 Excel Files).

I tried to create a Data Source with Data Source Type = SharePoint in a Gateway Cluster. However, it is throwing an error as per the

screenshot below:

I have referred to many links and have also bumped into an idea link wherein Microsoft seems to have resolved this issue of pooling up data from on-prem (SQL Database in our case) and cloud (SharePoint in our case) data sources but this doesn't seem to work as yet.

As soon as I select Authentication Method = OAuth2, and Privacy Level setting for this data source = None or Private or Organizational or Public, the Add button is greying out or Disabled per the screenshot above.

However, when I tried to create a fresh new Gateway Cluster, everything just works fine.

Requirement is to create a this new SharePoint Gateway under the existing Gateway Clusters.

FYI - Gateway is updated from September to the latest (October 2020) as of yesterday.

Can anyone please help me with what I'm doing wrong or is there any settings I need to check/change on the configured On-Premise Gateway or on the SharePoint Site?

Your time and help is greatly appreciated.

Thanks, C

Below is the complete Error Message if that helps:

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details