Sharepoint Request failed.The underlying connection was closed. The connection was closed unexpected

[ravikant_9]

Hi,

When trying to connect to Sharepoint list (On-Premises), getting the error. (Unable to connect. We encountered an error while trying to connect. Details: "Sharepoint: Request failed: The underlying connection was closed: The connection was closed unexpectedly.")

I can access the site in url by providing Windows Userid and password. When I try providing the Windows UserID and Password in Power BI Desktop, it doesn't connect.

Can anybody please help me in this?

 Ravi Kant

[v-chuncz-msft]

@ravikant_9,

Clear permissions in data source settings and check this post.

[ravikant_9]

Hi,

I followed the instructions and was able to go to next screen at least. But the same error is thrown again while loading the lists.

[ravikant_9]

@v-chuncz-msft,

Hi. I followed the instructions and was able to go to next screen at least. But the same error is thrown again while loading the lists.