The underlying connection was closed: An unexpected error occurred on a send(Sharepoint data Only)

Hi all,

Thank you in advance for taking the time to read this post.

I have built some dashboards where the data comes from Sharepoint as well as our SQL server. So prior to 9/12/2022 everything was working perfectly. But later, I started to get "The underlying connection was closed: An unexpected error occurred on a send." in all the data that is coming from Sharepoint. 

First I thought it was microsoft issue, but then I realised this issue following.

1. Home WIFI - The error only occurs when I am working from home with my  home wifi.
2. Home Lan/Office Wifi/Office Lan - The error doesn't occur when I use Lan at home or Office Wifi or Office Lan.
3. Mobile Hotspot - Surprisingly, the error doesn't occur when I connect my WIFI by releasing hotspot from my mobile phone. 

I thought it was an internet issue, but my download speed is 55 mbps and upload speed is 18 mbps (home wifi).
Home Wifi/Lan download speed - 54 mbps
Home Wifi/Lan Upload speed - 17 mbps
Home Wifi/Lan Ping - 18

Home Wifi/Lan Download Latency - 23
Home Wifi/Lan Upload Latency - 24
Mobili Hotspot download speed - 54 mbps

Mobile Hotspot upload speed - 21 mbps
Mobile Hotspot Ping - 24
Download Latency - 215
Mobitl Hotspot upload latency 177

Clearly speed is not an issue as my home wifi/lan have metrics similar. 

I contacted my internet provider and they've provided me with new and better router/modem but it is not working. 

Perhaps some setting on my Laptop that relates to my home wifi. 

Note : The issue is only when I refresh query in Power BI desktop or the query editor window, but it refreshes all well in Power BI online.

Has anyone experienced a situation like this before?