Hi all,

I'm using Excel 2013 with the Power Pivot add-in. The Power Pivot connects without any problem with my sql server database but when I try to run a query to retrieve the data, I get the following error message:

"An error occurred while processing table 'Query'.

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

Out of line object 'DataSource', referring to ID(s) '26c30925-cc9a-4f53-85ea-229a33a5e766', has been specified but has not been used.

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


The SQL Query is a very simple one (shown below):

Use MyDatabase

select Name, TravelAgencyID,TravelAgencyTypeCode, CountryCode, CreatedOn, CreatedBy

from TravelAgency

What might be the issue?