OLE DB or ODBC error: [DataSource.Error] Received an unexpected EOF or 0 bytes from the transport...

I have the same issue and it's hugely annoying. I think overall the connection between Power BI and Sharepoint files as well as OneDrive (files in the cloud) is terribly non-robust. I have many tables in query editor - easily 80 with 40 loaded to the data model - about 10 are from power bi dataflows, the rest are files on sharepoint or onedrive. The meat of it pulls and combines together about 60 excel files for a total of about 180 MB.  Is this too much for Power BI to handle??  The rest are just DIM tables of KB size.  And I can get "OLE DB or ODBC error: [DataSource.Error] Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host" or the same one you posted "Received an unepected EOF or 0 bytes from the transport stream" randomly. Sometimes it takes all day before I can get the data to load from query editor into the PBIX without an error.  Sometimes it works fine the first time. Power BI should work absolutely flawlessly with other microsoft products.  I'm not impressed.