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 connection dropped and reconnected.

 

Sharepoint error

 

 

I have already installed the latest version (May '22) of PBI and cleared my credentials (global & local) yet I am still receiving the same error.

 

Please help.

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hey, Do you try to connect to a sharepoint list or a file stored in SP. For SP connections, there are 3 connections avaliable in pbi desktop, if you want to connect to SP list, i recommend you to use Sharepoint online connection. If you connect to a file stored in SP, i would like to you web connection. Hope it is helpful! 

  • 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