Thursday, March 22, 2012 10:56 AM
When importing from SQL SErver 2005 to PowerPivot version 11.0.2100.60 (64 bit) I get the following errormess "
OLE DB or ODBC error: Requested conversion is not supported..
The current operation was cancelled because another operation in the transaction failed.
Out of line object 'DataSource', referring to ID(s) 'dcd89c8d-af69-487d-a0c9-f693cf0eb653', 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."
There is a Timestamp field in the Facttable but no data in it.
After deleting the timestamp field from the Facttable the import is working. Sound like a bug?!
Monday, March 26, 2012 6:54 AMModerator
Monday, March 26, 2012 12:07 PM
Hi Challen Fu,
I know about this.
But the question is if timestamp is supported by PowerPivot or is it a bug?
Tuesday, March 27, 2012 12:16 AM
Timestamp doesnt look like supported by PowerPivot. The data types supported are:
-- This posting is provided "AS IS" with no warranties, and confers no rights