locked
Datatype Timestamp causes error in import to PowerPivot RRS feed

  • Question

  • Hi,

    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?!


    Larra

    Thursday, March 22, 2012 10:56 AM

Answers

All replies

  • Hi Larra,

    Actually, you can click the button of Preview&Filter, then unselect the timestamp field. Then the timestamp field will not show in the PowerPivot. 


    Challen Fu

    TechNet Community Support

    Monday, March 26, 2012 6:54 AM
  • Hi Challen Fu,

    I know about this.

    But the question is if timestamp is supported by PowerPivot or is it a bug?

    Larra


    Larra

    Monday, March 26, 2012 12:07 PM
  • Larra,

    Timestamp doesnt look like supported by PowerPivot. The data types supported are:

    http://technet.microsoft.com/en-us/library/gg413463.aspx


    -- This posting is provided "AS IS" with no warranties, and confers no rights

    • Proposed as answer by Challen Fu Wednesday, March 28, 2012 7:00 AM
    • Marked as answer by Challen Fu Monday, April 2, 2012 9:56 AM
    Tuesday, March 27, 2012 12:16 AM