Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sharepoint Connection Error

Hello.   Recently I've been trying to connect to SP through PBI desktop and I have been failing to connect. I suspect the issue started when, as I was refreshing the dataset, the internet connectio...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Anonymous ,

 Try to add the cipher suites i mentioned. then it will work.

As stated in an above link https://docs.microsoft.com/en-us/sharepoint/troubleshoot/administration/authentication-errors-tls12-...

Sharepoint has moved to tls1.2

For TLS 1.2, the following cipher suites are supported by Azure Front Door:

  • TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
  • TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
  • TLS_DHE_RSA_WITH_AES_256_GCM_SHA384
  • TLS_DHE_RSA_WITH_AES_128_GCM_SHA256

these cypher suites are probably not in use on your server where the gateway is installed.

at least our server didn't have those.

 

Added these cypersuites rebooted the gateway server.

 

And   a way to bypass this situation, to build dataflows for Sharepoint sources, then using them to feed our models so that merges don't fails.

 

Similar question refer:

https://community.powerbi.com/t5/Issues/May-2021-Gateway-Error-SharePoint-Request-failed-The-underlying/idi-p/1857711/page/2#comments 

 

 

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


Best Regards

Lucien