sql - OLE DB or ODBC error. The current operation was cancelled because another operation in the transaction failed

Question

OLE DB or ODBC error.

An error occurred while processing table 'Query 1'.

The current operation was cancelled because another operation in the transaction failed.

Out of line object 'DataSourceView', referring to ID(s) 'Temp_DSV', has been specified but has not been used.

---

I got the above error when i ran a query in Power Pivot for excel. Can somebody tell me , what might be the reason?

Answer 1

Maybe your query exceeds the memory limitations of 32bit Excel. Try to limit your query with a WHERE clause.

Also see this related question:

How to debug OLE DB or ODBC error (import data from MySql to Excel)