Power BI on premise gateway connection error

[Anonymous]

Hi team,

We have configured a Power BI on premise gateway on one server in our infrastructure. When configuring various data sources under the gateway, most of the sources are working except any SharePoint related data source (Sharepoint list or Sharepoint saved Excel file). 

The error we are getting is: 

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

Activity ID:	c20dbdbe-f0c6-4fc5-a669-4880bc696354
Request ID:	b37445fb-770c-7a88-808b-09053602b46a
Cluster URI:	https://wabi-south-central-us-redirect.analysis.windows. net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Thu Nov 01 2018 12:55:52 GMT+0200 (Eastern European Standard Time)
Version:	13.0.7149.194

machpaUrpCluster:

Timeout occurred when sending or receiving a request.

We have extended the Gateway timeout from 50 seconds to 2 minutes, but the error still occurs. 

This error has occured for the first time over the last weekend, when on the SharePoint server were installed the following updates: KB4462926, KB4462949, KB4462941. 

Can you please help me with some clues on why this is happening?

Thanks,

Theo 

[Anonymous]

@Anonymous,

What is the version of Power BI Gateway do you use? Could you please export gateway log following the guide in this article and then share the gateway log here?

Regards,
Lydia

[Anonymous]

Hi Lydia,

Our current version is 3000.0.144.3, which I think is the latest. Please find attached our logs in the below Google Drive link:

https://drive.google.com/file/d/1SA0hcYcpw85FO1WnbWr2r3gB2Cn6Q5yz/view?usp=sharing

Many thanks,

Theo

[Anonymous]

@Anonymous,

I found the following error message in your log:

"ErrorCode: authentication_canceled
EnterpriseGatewayConfigurator.exe Error: 0 : Exception: Microsoft.PowerBI.DataMovement.GatewayCommon.ADAuthenticationException: Failed to sign in. Please verify your credentials and try again. ---> Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: authentication_canceled: User canceled authentication"

Are you able to sign in Power BI gateway configurator? And what authentication type do you use to connect to SharePoint data source? Please verify if the credentials for Power  BI gateway and sharepoint data source are correct.

Regards,
Lydia

[ami90]

Hii

i am having an issue that whenever i publish my report to the premised sql server using gateway using credentials  it provides me an errror and when i reagain check my password and renter to it it again shows the same error. is there any solution to this problem.

[ami90]

Data Source Settings users @Unable to connect: We encountered an error while trying to cchnect to . Details: •We could not register this data source for any gateway instances within this cluster. Piease find details specific errors for each gateway.

This error is displayed over my system screen and whwn i again check myy password and all then also it shows the same error