Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Upload Error

Dear Team, Am trying to upload an excel into my power Bi Model and every time I do it gives me the above error below. The file extension is .XLSX but even a CSV or a .xls is not working
Need Help
HotChilli's avatar
HotChilli
Community Champion
7 years ago

The error appears to be "We couldn't convert to Duration"

 

We can't see what steps are failing in the picture you have posted.  Presumably there is a column which powerbi is trying to convert to Duration type and that fails due to problems with the data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the response. Below is the detail error that is generated.

     

    Feedback Type:

    Frown (Error)

     

    Error Message:

    [DataFormat.Error] We couldn't convert to Duration.

     

    Stack Trace:

       at Microsoft.Mashup.Engine1.Runtime.DurationValue.TryParse(String value, TimeSpan& timeSpan)

       at Microsoft.Mashup.Engine1.Runtime.Library._Value.FromTextFunctionValue.GetValueAndType(Value text, CultureInfo cultureInfo, TypeValue& typeValue)

       at Microsoft.Mashup.Engine1.Runtime.Library.ValueAndType.FromTextFunctionValue.TypedInvoke(Value text, Value culture)

       at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)

       at Microsoft.Mashup.Host.Document.Formulas.EngineTextTypeDetector.DetectType(String text)

       at Microsoft.Mashup.Host.Document.Formulas.OriginalAndInferredTypeDetector.NewValue(TypeHandle originalType, String value)

       at Microsoft.Mashup.Host.Document.Formulas.AutoTypeDetector.PopulateDetectors(ITableView tableView, List`1 detectors, Int32 maxRows)

       at Microsoft.Mashup.Host.Document.Formulas.AutoTypeDetector.CreateTableHeaderAndTypeDetector(IEngineHost engineHost, IEngine engine, ITableView tableView, Boolean allowHeaders, Int32 maxRows)

       at Microsoft.Mashup.Host.Document.Formulas.TaskInvokeFormula.GetOrCreateTableHeaderAndTypeDetector(PackageEditor packageEditor, TaskCreationContext taskCreationContext, TableResult tableResult)

       at Microsoft.Mashup.Host.Document.Formulas.PromoteHeadersFormula.TryCreate(FormulaReference baseFormulaReference, TaskCreationContext taskCreationContext, Boolean& showBuilder)

       at Microsoft.Mashup.Host.Document.TaskFormula.TryCreateTaskFormula(FormulaSet formulaSet, IEngine engine, String formulaID, FormulaReference baseFormulaReference, TaskCreationContext selection, Formula& taskFormula, Boolean& showBuilder, Boolean& merged, Boolean& shouldRefreshParts)

       at Microsoft.Mashup.Host.Document.FormulaEditor.ApplyTaskCore(PackageEditor packageEditor, FormulaSet formulaSet, String sectionName, String baseFormulaName, String baseFormulaPartName, String formulaID, TaskCreationContext taskCreationContext, String& actualFormulaName, String& actualFormulaPartName, TaskFormula& taskFormula, Boolean& hasBuilder, Boolean& merged, Boolean& shouldRefreshParts)

       at Microsoft.Mashup.Host.Document.FormulaEditor.ApplyTask(PackageEditor packageEditor, FormulaSet formulaSet, String sectionName, String baseFormulaName, String baseFormulaPartName, String formulaID, TaskCreationContext taskCreationContext, ApplyTaskResult& result)

       at Microsoft.Mashup.Host.Document.FormulaEditor.TryApplySubsequentFormulas(PackageEditor packageEditor, FormulaPath baseFormulaPath, PreviewResult previewResult, Boolean isHeaderDetectionEnabled, Boolean isTypeDetectionEnabled, ApplyTaskResult& applyTaskResult)

       at Microsoft.Mashup.Host.Document.Model.Query.TryApplySubsequentFormulas(PreviewResult previewResult)

       at Microsoft.Mashup.Client.UI.Shared.Ux.Navigator.QueryNavigatorPreviewHost.<>c__DisplayClass17_0.<SetPreviewFromQuery>b__1(PreviewReference preview)

       at Microsoft.Mashup.Host.Document.Evaluation.PreviewEvaluationQueue.<>c__DisplayClass48_0.<OnPreviewComplete>b__0()

       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

     

    Stack Trace Message:

    [DataFormat.Error] We couldn't convert to Duration.

     

    Invocation Stack Trace:

       at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

       at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)

       at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)

       at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)

       at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()

       at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)

       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

       at System.Delegate.DynamicInvokeImpl(Object[] args)

       at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

       at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

       at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

       at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

       at System.Windows.Forms.Control.WndProc(Message& m)

       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

       at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

       at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)

       at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)

       at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.NavigatorFloatingDialog.ShowEditLoad(IWindowHandle owner, IUIHost uiHost, Query query, ITelemetryService telemetryService, Boolean multiSelectionEnabledByDefault, IWebTableImporterHost webTableImporterHost)

       at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.ShowNavigator(Query query)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& importedQueries)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.ImportNavigationSource(Query query)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass76_1.<OnQuerySettingsResolved>b__0()

       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

       at System.Delegate.DynamicInvokeImpl(Object[] args)

       at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

       at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

       at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

       at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

       at System.Windows.Forms.Control.WndProc(Message& m)

       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

       at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

       at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)

       at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)

       at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()

       at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()

       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

       at Microsoft.PowerBI.Client.Program.Main(String[] args)

     

     

    InnerException.Stack Trace Message:

    Value 'Duration' was either too large or too small for TimeSpan.

     

    InnerException.Stack Trace:

       at System.Xml.XmlConvert.ToTimeSpan(String s)

       at Microsoft.Mashup.Engine1.Runtime.DurationValue.TryParse(String value, TimeSpan& timeSpan)

     

    InnerException.Invocation Stack Trace:

       at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

       at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)

       at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)

       at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)

       at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)

       at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()

       at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)

       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

       at System.Delegate.DynamicInvokeImpl(Object[] args)

       at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

       at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

       at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

       at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

       at System.Windows.Forms.Control.WndProc(Message& m)

       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

       at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

       at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)

       at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)

       at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.NavigatorFloatingDialog.ShowEditLoad(IWindowHandle owner, IUIHost uiHost, Query query, ITelemetryService telemetryService, Boolean multiSelectionEnabledByDefault, IWebTableImporterHost webTableImporterHost)

       at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.ShowNavigator(Query query)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& importedQueries)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.ImportNavigationSource(Query query)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)

       at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass76_1.<OnQuerySettingsResolved>b__0()

       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

       at System.Delegate.DynamicInvokeImpl(Object[] args)

       at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

       at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

       at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

       at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

       at System.Windows.Forms.Control.WndProc(Message& m)

       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

       at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

       at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)

       at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)

       at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()

       at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()

       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

       at Microsoft.PowerBI.Client.Program.Main(String[] args)

     

     

    Model Default Mode:

    Empty

     

    Snapshot Trace Logs:

    C:\Users\sgitonga\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot507270321.zip

     

    Performance Trace Logs:

    C:\Users\sgitonga\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

     

    Disabled Preview Features:

    PBI_shapeMapVisualEnabled

    PBI_SpanishLinguisticsEnabled

    PBI_NewWebTableInference

    PBI_showIncrementalRefreshPolicy

    PBI_showManageAggregations

    PBI_improvedFilterExperience

    PBI_qnaLiveConnect

    PBI_keyDrivers

    PBI_userFavoriteResourcePackagesEnabled

     

    Disabled DirectQuery Options:

    TreatHanaAsRelationalSource

     

    Cloud:

    GlobalCloud

     

    Formulas:

     

     

    section Section1;

     

    shared Sheet = let

        Source = Excel.Workbook(File.Contents("C:\Users\sgitonga\OneDrive - Simba Corporation Ltd\Desktop\NV BI POC\2017 NV Sales.xls"), null, true)

    in

        Source;

     

    shared #"Sheet (2)" = let

        Source = Excel.Workbook(File.Contents("C:\Users\sgitonga\OneDrive - Simba Corporation Ltd\Desktop\NV BI POC\2017 NV Sales.xls"), null, true),

        Sheet1 = Source{[Name="Sheet"]}[Data]

    in

        Sheet1;

     

    shared #"NavigatorBase_b173928b-485f-44a2-b9fb-d92334187bb9" = let

        Source = Excel.Workbook(File.Contents("C:\Users\sgitonga\OneDrive - Simba Corporation Ltd\Desktop\NV BI POC\2017 NV Sales.xls"), null, true)

    in

        Source;