OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the provider:

Hi robinhood276 

You're encountering an error where Power Query loads the table fine in the editor, but when you actually apply and load it into Power BI Desktop, it fails with: "Invalid operation. The connection is closed." This usually means the data source connection is timing out or dropping during the final data load phase, even though preview works. Often, this happens with large tables, slow network/data gateway connections, or providers that close idle sessions. In short, the issue isn't with your query logic but with the connection not staying open long enough when loading to the model.