Setting up on-prem gateway connecting to MySQL and Sharepoint data source

[Anonymous]

Hi,

I have a pbi report which connects to mysql and sharepoint datasource. I am trying to configure an on-prem gateway to run scheduled refresh, however I am unable to do so:

When I try adding hte Sharepoint source to the gateway, selecting Windows as an authentication method and inserting my username and credentials which I normally use to login to SharePoint, I receive the following warning - 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."

Invalid connection credentials

Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Mon Jan 06 2020 09:22:09 GMT+1100 (AUS Eastern Daylight Time)
Service version:	13.0.11747.315
Client version:	1912.2.031

How can I fix this?

Also, I have read a thread that pbi cannot accomodate setting up an on-prem gateway connecting to 2 data sources. Instead you would need to use a personal gateway to run scheduled refreshes. However, this thread was posted in 2016. Has there been any updates since then? Can the on prem gateway be used to connect to two data sources?

Kind Regards,

I

[v-shex-msft]

HI @Anonymous,

What type of SharePoint data source did you use? Sharepoint online or SharePoint on-premise? If you are working with an on-premise SharePoint that deploys in private networks, please enable the proxy feature on your gateway.

How to Get Your Question Answered Quickly 

Configure proxy settings for the on-premises data gateway 

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @v-shex-msft ,

I am currently useing hte Sharepoint online data source.

Regards,

I

[v-shex-msft]

HI @Anonymous ,

AFAIK, there are a few type of connectors can link to SharePoint online datasorue, can you please explain more about them?(e.g. SharePoint list, SharePoint folder, SharePoint online list, file, Odata...)

Your data source can't be refreshed because the credentials are invalid. 

In addition, any advanced operations apply in query tables? (merge, combine, reference, custom function...)

Regards,

Xiaoxin Sheng

[GilbertQ]

Hi there

Make sure you have got this enabled on your Gateway in the Power BI Service as shown below. This will allow you to connect to cloud and on-prem data sources.