Data Sets not refreshing

[DanielDiAngelo]

for some time we have receieved intermittent TDS Protocol errors from our online data refreshes..  but a few weeks ago everything came off the rails.  here is the setup:   Personal gateway, feeding 15-20 data sets with upwards of 100 queries..been working fine for more than 3 yrs.  2 wks ago, both the gateway feeds and the desktop feeds have died for at least half of those data sets.  all the queries are setup as import.  the errors now read:  

An error happened while reading data from the provider: 'Invalid operation. The connection is closed.' 

OR 

An error happened while reading data from the provider: 'A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)'

OR

Microsoft SQL: Protocol error in TDS stream

These errors are the online codes.  in desktop we also get:

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.

OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the provider: 'Invalid operation. The connection is closed.

These errors happen 99% of the time.  with the very rare random successful run..

What hasnt fixed it:  rolling back to august desktop

tweaking queries to remove one table worked for a minute, then didnt again. Disabling refresh on failing queries worked for one file.  but same query in different file did not work.  for clarity these are 20 item selects with just 3 tables joined from a SQL database.

Any help Please.  What do we try next..  

[v-chuncz-msft]

@DanielDiAngelo 

A similar issue has been reported internally, so stay tuned. 

IcM 266426118

[DanielDiAngelo]

Update:  Power BI october 2021 did not fix the issue.  Also went to excel and used the get data feature with the same query failing in Power BI.  Same result.  Transport level error. connection closed.

Is it a sql issue, a power query issue, firewall problem?  

can you tell me how to monitor the progress of the resolution for the internal reports?

Thanks

daniel

[satindenave]

same issue with me also can u provide  the solution for this please

[DanielDiAngelo]

Our issue was in a network switch which was throttling our bandwidth.  This was shutting down all of our larger pulls.   So the punchline was hardware not software.  We only discovered it because that switch ended up failing..

[satindenave]

Thanks will connect with our network team check for this