Gateway Sharepoint Error -2147467259

Hi Anonymous 

It appears that you cannot connect to the dataset, if you can ensure that you have correctly configured the data source settings?

Hi, I found this helpful. It seems to be that it's not neccessary a gateway when we work with sharepoint lists.

Solved: Sharepoint Gateway Connection Failure - Microsoft Power BI Community

Hi Anonymous ,

The 400 ERROR means a bad http request. Please updata on-premise gateway to the lastest version. If you already have updated the gateway to the latest version, then you can refer to steps below for troubleshooting.

1. Check if the server is using a proxy and the proxy. Some proxies restrict traffic to only ports 80 and 443. By default, communication to Azure Service Bus will occur on ports other than 443.

2. You can force the gateway to communicate with Azure Service Bus using HTTPS instead of direct TCP. You will need to modify the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file. Change the value from AutoDetect to Https. This file is located, by default, at C:\Program Files\On-premises data gateway.

3. Restart the gateway and check if the issue persists. 

• To stop the service, run this command:

  ''' net stop PBIEgwService '''

• To start the service, run this command:

  ''' net start PBIEgwService '''

4. You may export the data gateway log by selecting Diagnostics and then selecting the Export logs link near the bottom of the page. Reference: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting.

similar error question refer:

https://community.powerbi.com/t5/Service/We-could-not-register-this-data-source-for-any-gateway-instances/m-p/605338 

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

Best Regards

Lucien

Hi Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

Hello, I have the same problem with connection on PBI Cloud. I´m trying to connect and i get an error:

• Data source error{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the SharePoint source are invalid. (Source at https://telcocloud.sharepoint.com/sites/PrevdzkaCCOperations.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath","detail":{"type":1,"value":"https://telcocloud.sharepoint.com/sites/PrevdzkaCCOperations"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"https://telcocloud.sharepoint.com/sites/PrevdzkaCCOperations"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SharePoint\",\"path\":\"https://telcocloud.sharepoint.com/sites/PrevdzkaCCOperations\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}}
• Cluster URIWABI-NORTH-EUROPE-N-PRIMARY-redirect.analysis.windows.net
• Activity ID8ee43327-95ef-48a1-8337-935d0d3118c4
• Request ID2358cd56-df61-0ddd-2d20-1876f5fd3323
• Time2023-10-12 12:03:54Z
  
  In PBI Desktop refresh works without any problem. Thank you for any advice.