locked
Data Type convertion Error:PowerPivot for Excel RRS feed

  • Question

  • I am trying to create a Pivot Chart using PowerPivot Adds-in and Excel 2010. When i import my data from Analysis Services 2008 R2 to excel using PowerPivot window, it converts my calendar date to string(text). And now when i try to convert it using data type text to date in powerpivot it gives me below error message:

    ============================
    Error Message:
    ============================

    The following system error occurred:  Type mismatch.
    PowerPivot database error: Datatype conversion failed for [Table: 'Query', Column: '', Value: 'Unknown'].

    ----------------------------
    Failed to change column data type.

    ============================
    Call Stack:
    ============================

       at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.ExecuteCaptureLogAndProcessResults(OperationType type, Boolean cancellable, Boolean raw)
       at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.ExecuteAMOCode(OperationType type, OperationCancellability cancellable, AMOCode code)
       at Microsoft.AnalysisServices.Modeler.Storage.DataModelingTable.Update(UpdateOptions updateOptions)
       at Microsoft.AnalysisServices.Modeler.Storage.DataModelingView.ChangeColumnsDataType(IList`1 columns, OleDbType dataType)
    ----------------------------
       at Microsoft.AnalysisServices.Modeler.Storage.DataModelingView.ChangeColumnsDataType(IList`1 columns, OleDbType dataType)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetGridControl.ChangeColumnsDataType(List`1 columns, BasicDataType dataType)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetPanel.ChangeColumnsDataType(List`1 columns, BasicDataType dataType)
       at Microsoft.AnalysisServices.Modeler.ClientWindow.DataTypeSelectionChanged(UInt32 newSelectedIndex, String newSelectedString)

    ============================

    Any thoughts is greatly appreciated.

    -Shardul

     


    sshah
    Wednesday, June 22, 2011 6:36 PM

Answers