Hello, I'm trying to direct load some data from a single source (Tibco TDV). I have 5 different queries. 4 of them run fine and the data is pulled in. On the 5th (the largest query with several million rows), it gets to about 700k rows before it throws the error below. It consistently errors at the same point. I know it's not running into the size limit of Power BI at this point. I can't find anything online for a similar error and am at a loss. Anyone have any idea what might be causing this?
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ERROR [] Commit failed [txn-1920010] Unable to commit connection for data source "<data source folder>". SQL State = null SQL Error Code = 0 [data-2911010] Unable to commit connection for data source "<data source folder>". SQL State = null SQL Error Code = 0 [data-2911010] Cause: A commit request was issued 5 minutes ago to data source "<data source folder>". At the time, the data source was still being used and so the request was delayed. The other thread is still busy so the connection will now be forcibly closed. [Log ID: 860eb3b3-be6e-4d20-8491-74179d3235f1] . '.
