Power Query error, HELPPPP

%3CLINGO-SUB%20id%3D%22lingo-sub-1248570%22%20slang%3D%22en-US%22%3EPower%20Query%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1248570%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20keep%20getting%20this%20error%20when%20trying%20to%20close%20and%20load%20a%20csv%20and%20access%20file%20to%20my%20excel%20worksheet%3A%3C%2FP%3E%3CP%3EFeedback%20Type%3A%3CBR%20%2F%3EFrown%20(Error)%3C%2FP%3E%3CP%3EError%20Message%3A%3CBR%20%2F%3EExternal%20component%20has%20thrown%20an%20exception.%3C%2FP%3E%3CP%3EStack%20Trace%3A%3CBR%20%2F%3Eat%20Microsoft.Mashup.ScriptDom.TSql100Parser.Parse(IList%601%20tokens%2C%20IList%601%26amp%3B%20errors)%3CBR%20%2F%3Eat%20Microsoft.Mashup.ScriptDom.TSqlParser.Parse(TextReader%20input%2C%20IList%601%26amp%3B%20errors%2C%20Int32%20startOffset%2C%20Int32%20startLine%2C%20Int32%20startColumn)%3CBR%20%2F%3Eat%20Microsoft.Mashup.SqlTranslator.SqlParser.Parse(String%20sql)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Host.ProviderShared.MashupFileHost.GetEvaluator(IMashupResourcePackage%20mashupResourcePackage%2C%20Guid%20dialect%2C%20String%20commandText%2C%20Boolean%20forColumnInfo%2C%20IMashupContext%20mashupContext)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Host.ProviderShared.MashupFileHost.Microsoft.Mashup.OleDbProvider.IMashupDocument.CreateEvaluator(Guid%20dialect%2C%20String%20commandText%2C%20Boolean%20forColumnInfo)%3CBR%20%2F%3Eat%20Microsoft.Mashup.OleDbProvider.MashupSession.CreateRowset(Guid%20dialect%2C%20String%20commandText%2C%20Boolean%20forColumnInfo)%3CBR%20%2F%3Eat%20Microsoft.Mashup.OleDbProvider.MashupCommand.CreateRowset(Boolean%20forColumnInfo)%3CBR%20%2F%3Eat%20Microsoft.Mashup.OleDbProvider.TracingCommand.CreateRowset(Boolean%20forColumnInfo)%3C%2FP%3E%3CP%3EStack%20Trace%20Message%3A%3CBR%20%2F%3EExternal%20component%20has%20thrown%20an%20exception.%3C%2FP%3E%3CP%3EInvocation%20Stack%20Trace%3A%3CBR%20%2F%3Eat%20Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String%20exceptionStackTrace%2C%20String%20invocationStackTrace%2C%20String%20exceptionMessage)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String%20message%2C%20Exception%20exception%2C%20Nullable%601%20stackTraceInfo%2C%20String%20messageDetail)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.RaiseErrorDialog(IWindowHandle%20activeWindow%2C%20IUIHost%20uiHost%2C%20FeedbackPackageInfo%20feedbackPackageInfo%2C%20Exception%20e%2C%20LocalizedString%20dialogTitle%2C%20LocalizedString%20dialogMessage%2C%20Boolean%20useGDICapture)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle%20activeWindow%2C%20IUIHost%20uiHost%2C%20FeedbackPackageInfo%20feedbackPackageInfo%2C%20Exception%20e%2C%20Boolean%20useGDICapture)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.%26lt%3B%26gt%3Bc__DisplayClass14_0.%3CHANDLEEXCEPTION%3Eb__0()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext%20context%2C%20Action%20callback)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception%20e)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.OleDbProvider.ExcelMashupClassFactory.TraceAndReportException(String%20method%2C%20Exception%20exception)%3CBR%20%2F%3Eat%20Microsoft.Mashup.OleDbProvider.TracingCommand.CreateRowset(Boolean%20forColumnInfo)%3CBR%20%2F%3Eat%20Microsoft.OleDb.Command.Microsoft.OleDb.ICommandText.Execute(IntPtr%20punkOuter%2C%20Guid%26amp%3B%20iid%2C%20DBPARAMS*%20pParams%2C%20DBROWCOUNT*%20pcRowsAffected%2C%20IntPtr%26amp%3B%20ppv)%3CBR%20%2F%3Eat%20Microsoft.OleDb.PInvokeInterop.CommandTextTypeInfo.Execute(IntPtr%20objHandle%2C%20IntPtr%20pUnkOuter%2C%20Guid%26amp%3B%20iid%2C%20DBPARAMS*%20pParams%2C%20DBROWCOUNT*%20cRowsAffected%2C%20IntPtr%26amp%3B%20ppv)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.NativeExcelFunctionsNetStandard.LoadQuery(IntPtr%20workbookPointer%2C%20MarshalledConnectionInfo%5B%5D%20connectionInfo%2C%20Boolean%20showDialog%2C%20NativeFillObjectType%20defaultFillObjectType%2C%20Boolean%20defaultLoadToDataModel%2C%20CommitQueryChangesCallback%20commitCallback%2C%20DiscardQueryChangesCallback%20discardCallback)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Fill.PassiveFillManager.NotifyExcelOnQueryLoading(IWorkbookIdentity%20workbookIdentity%2C%20IEnumerable%601%20addedQueries%2C%20Boolean%20promptForLoadOptions%2C%20FillObjectType%20defaultsFillObjectType%2C%20Boolean%20defaultAddToDataModel%2C%20CommitQueryChangesCallback%20commitCallback%2C%20DiscardQueryChangesCallback%20discardCallback)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Fill.PassiveFillManager.%26lt%3B%26gt%3Bc__DisplayClass3_0.%3CTRYINITIALIZELOADFLOW%3Eb__2()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeRefreshCachingServices.InvokeWithRefreshSession(IWorkbook%20workbook%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Fill.PassiveFillManager.TryInitializeLoadFlow(IWindowHandle%20ownerWindow%2C%20IWorkbookIdentity%20workbookIdentity%2C%20Queries%20queries%2C%20QueriesDiffs%20queriesDiffs%2C%20InitialFillTargets%20defaultFillTargets%2C%20QueriesCommitPoint%20queriesCommitPoint%2C%20IQueryServices%20queryServices%2C%20Action%20onFillStarted%2C%20Boolean%20promptForLoadOptions%2C%20Boolean%20allowExistingWorksheet%2C%20Boolean%20showCancelConfirmation)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle%20ownerWindow%2C%20IWorkbookIdentity%20workbookIdentity%2C%20QueriesEditorParameters%20queriesEditorParameters%2C%20Queries%20queries%2C%20IUndoScope%20undoScope)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.%26lt%3B%26gt%3Bc__DisplayClass12_1.%3CSHOWMODALQUERIESEDITORWINDOW%3Eb__1(IUndoScope%20undoScope)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.%26lt%3B%26gt%3Bc__DisplayClass6_0.%3CINVOKEUNDOABLEACTION%3Eb__0()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook%20workbook%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook%20workbook%2C%20UndoableActionType%20actionType%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook%20workbook%2C%20UndoableActionType%20actionType%2C%20Action%601%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.%26lt%3B%26gt%3Bc__DisplayClass12_0.%3CSHOWMODALQUERIESEDITORWINDOW%3Eb__0()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook%20workbook%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle%20ownerWindow%2C%20IWorkbookIdentity%20workbookIdentity%2C%20QueriesEditorParameters%20queriesEditorParameters%2C%20Queries%20queries)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.DialogManager.EditNewQuery(QueriesCommitPoint%20queriesCommitPoint%2C%20Query%20query%2C%20IWindowHandle%20ownerWindow%2C%20IWorkbookIdentity%20workbookIdentity%2C%20JsonUpdate%20builderResults%2C%20Boolean%20isBlankQuery)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass58_1.%3CONIMPORTSUCCESS%3Eb__0(IUndoScope%20undoScope)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.%26lt%3B%26gt%3Bc__DisplayClass6_0.%3CINVOKEUNDOABLEACTION%3Eb__0()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook%20workbook%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook%20workbook%2C%20UndoableActionType%20actionType%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook%20workbook%2C%20UndoableActionType%20actionType%2C%20Action%601%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.OnImportSuccess(IEnumerable%601%20importedQueries%2C%20DataImportDestination%20destination)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.DataImporter.ProcessImportedQueries(IEnumerable%601%20importedQueries%2C%20DataImportDestination%20destination)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.OnTablePreviewDialogAction(Query%20query%2C%20TablePreviewDialogAction%20dialogAction)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass54_0.%3CIMPORTTEXTSOURCE%3Eb__0(IWorkbook%20workbook)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass55_1.%3CNOTIFYGETDATAPRESENCE%3Eb__1()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook%20workbook%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass55_0.%3CNOTIFYGETDATAPRESENCE%3Eb__0(IWorkbook%20workbook)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass56_0.%3CINVOKEONWORKBOOK%3Eb__0(IWorkbook%20workbook%2C%20IWindowContext%20windowContext)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook%5BT%5D(Func%603%20action%2C%20T%20defaultValue)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook(Action%601%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.NotifyGetDataPresence(Action%601%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.ImportTextSource(Query%20query%2C%20PreviewResult%20previewResult%2C%20String%20formulaTitle)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult%20preview%2C%20Query%20query%2C%20String%20sourceID%2C%20String%20formulaTitle%2C%20Nullable%601%20explicitImportDestination%2C%20Boolean%20isNewQuery%2C%20Boolean%20isFromEditor)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query%20query%2C%20String%20sourceID%2C%20String%20formulaTitle%2C%20Boolean%20isNewQuery%2C%20Boolean%20isFromEditor%2C%20Nullable%601%20explicitImportDestination)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass62_0.%3CGETPREVIEWRESULT%3Eb__1()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook%20workbook%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook%20workbook%2C%20UndoableActionType%20actionType%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass62_0.%3CGETPREVIEWRESULT%3Eb__0(IWorkbook%20workbook)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass55_1.%3CNOTIFYGETDATAPRESENCE%3Eb__1()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook%20workbook%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass55_0.%3CNOTIFYGETDATAPRESENCE%3Eb__0(IWorkbook%20workbook)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass56_0.%3CINVOKEONWORKBOOK%3Eb__0(IWorkbook%20workbook%2C%20IWindowContext%20windowContext)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook%5BT%5D(Func%603%20action%2C%20T%20defaultValue)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook(Action%601%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.NotifyGetDataPresence(Action%601%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.GetPreviewResult(Query%20query%2C%20String%20sourceID%2C%20String%20formulaTitle%2C%20Boolean%20isNewQuery%2C%20Boolean%20isFromEditor%2C%20Nullable%601%20explicitImportDestination)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.DataImporter.%26lt%3B%26gt%3Bc__DisplayClass78_1.%3CONQUERYSETTINGSRESOLVED%3Eb__0()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler%20exceptionHandler%2C%20Action%20action)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.%26lt%3B%26gt%3Bc__DisplayClass3_0.%3CPOST%3Eb__0(Object%20null)%3CBR%20%2F%3Eat%20System.RuntimeMethodHandle.InvokeMethod(Object%20target%2C%20Object%5B%5D%20arguments%2C%20Signature%20sig%2C%20Boolean%20constructor)%3CBR%20%2F%3Eat%20System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object%20obj%2C%20Object%5B%5D%20parameters%2C%20Object%5B%5D%20arguments)%3CBR%20%2F%3Eat%20System.Delegate.DynamicInvokeImpl(Object%5B%5D%20args)%3CBR%20%2F%3Eat%20System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry%20tme)%3CBR%20%2F%3Eat%20System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object%20obj)%3CBR%20%2F%3Eat%20System.Threading.ExecutionContext.RunInternal(ExecutionContext%20executionContext%2C%20ContextCallback%20callback%2C%20Object%20state%2C%20Boolean%20preserveSyncCtx)%3CBR%20%2F%3Eat%20System.Threading.ExecutionContext.Run(ExecutionContext%20executionContext%2C%20ContextCallback%20callback%2C%20Object%20state%2C%20Boolean%20preserveSyncCtx)%3CBR%20%2F%3Eat%20System.Threading.ExecutionContext.Run(ExecutionContext%20executionContext%2C%20ContextCallback%20callback%2C%20Object%20state)%3CBR%20%2F%3Eat%20System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry%20tme)%3CBR%20%2F%3Eat%20System.Windows.Forms.Control.InvokeMarshaledCallbacks()%3CBR%20%2F%3Eat%20System.Windows.Forms.Control.WndProc(Message%26amp%3B%20m)%3CBR%20%2F%3Eat%20System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message%26amp%3B%20m)%3CBR%20%2F%3Eat%20System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message%26amp%3B%20m)%3CBR%20%2F%3Eat%20System.Windows.Forms.NativeWindow.Callback(IntPtr%20hWnd%2C%20Int32%20msg%2C%20IntPtr%20wparam%2C%20IntPtr%20lparam)%3C%2FPOST%3E%3C%2FONQUERYSETTINGSRESOLVED%3E%3C%2FINVOKEONWORKBOOK%3E%3C%2FNOTIFYGETDATAPRESENCE%3E%3C%2FNOTIFYGETDATAPRESENCE%3E%3C%2FGETPREVIEWRESULT%3E%3C%2FGETPREVIEWRESULT%3E%3C%2FINVOKEONWORKBOOK%3E%3C%2FNOTIFYGETDATAPRESENCE%3E%3C%2FNOTIFYGETDATAPRESENCE%3E%3C%2FIMPORTTEXTSOURCE%3E%3C%2FINVOKEUNDOABLEACTION%3E%3C%2FONIMPORTSUCCESS%3E%3C%2FSHOWMODALQUERIESEDITORWINDOW%3E%3C%2FINVOKEUNDOABLEACTION%3E%3C%2FSHOWMODALQUERIESEDITORWINDOW%3E%3C%2FTRYINITIALIZELOADFLOW%3E%3C%2FHANDLEEXCEPTION%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EError%20Code%3A%3CBR%20%2F%3E-2147467259%20(0x80004005)%3C%2FP%3E%3CP%3ESupports%20Premium%20Content%3A%3CBR%20%2F%3ETrue%3C%2FP%3E%3CP%3EFormulas%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3Esection%20Section1%3B%3C%2FP%3E%3CP%3Eshared%20%23%22revenue%20history%22%20%3D%20let%3CBR%20%2F%3ESource%20%3D%20Csv.Document(File.Contents(%22C%3A%5CUsers%5CO%5CDownloads%5CSupport%20_history.csv%22)%2C%5BDelimiter%3D%22%2C%22%2C%20Columns%3D5%2C%20Encoding%3D65001%2C%20QuoteStyle%3DQuoteStyle.None%5D)%2C%3CBR%20%2F%3E%23%22Promoted%20Headers%22%20%3D%20Table.PromoteHeaders(Source%2C%20%5BPromoteAllScalars%3Dtrue%5D)%2C%3CBR%20%2F%3E%23%22Changed%20Type%22%20%3D%20Table.TransformColumnTypes(%23%22Promoted%20Headers%22%2C%7B%7B%22Year%22%2C%20Int64.Type%7D%2C%20%7B%22Business%20Year%22%2C%20Int64.Type%7D%2C%20%7B%22Revenue%20(%24mil)%22%2C%20type%20number%7D%2C%20%7B%22Units%20Sold%22%2C%20Int64.Type%7D%2C%20%7B%22Notes%22%2C%20type%20text%7D%7D)%3CBR%20%2F%3Ein%3CBR%20%2F%3E%23%22Changed%20Type%22%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIve%20tried%20restarting%2C%20copy%2Fpaste.%20Not%20sure%20what%20to%20do%20and%20I%20need%20to%20fix%20this%20in%20order%20to%20complete%20my%20school%20assignment.%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20recently%20downloaded%20Sims%204%20onto%20my%20laptop.%20Could%20that%20be%20a%20reason%20for%20this%20error%20message%20or%20are%20the%202%20not%20correlated%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1248570%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1250139%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20error%2C%20HELPPPP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F592160%22%20target%3D%22_blank%22%3E%40k_striick%3C%2FA%3E%26nbsp%3BI%20would%20focus%20on%20one%20program%20at%20a%20time.%20So%20maybe%20start%20with%20CSV%20file.%20Are%20you%20trying%20to%20import%20a%20data%20set%20once%20or%20is%20this%20a%20spreadsheet%20that%20will%20continue%20to%20pull%20in%20info%20from%20an%20updated%20CSV%20file%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20bit%20more%20information%20on%20how%20you%20are%20building%20your%20excel%20file%20would%20be%20helpful.%26nbsp%3B%3C%2FP%3E%3CP%3EPretty%20easy%20to%20go%20into%20excel%2C%20Data%20and%20import%20data%20from%20a%20CSV%20file.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, I keep getting this error when trying to close and load a csv and access file to my excel worksheet:

Feedback Type:
Frown (Error)

Error Message:
External component has thrown an exception.

Stack Trace:
at Microsoft.Mashup.ScriptDom.TSql100Parser.Parse(IList`1 tokens, IList`1& errors)
at Microsoft.Mashup.ScriptDom.TSqlParser.Parse(TextReader input, IList`1& errors, Int32 startOffset, Int32 startLine, Int32 startColumn)
at Microsoft.Mashup.SqlTranslator.SqlParser.Parse(String sql)
at Microsoft.Mashup.Host.ProviderShared.MashupFileHost.GetEvaluator(IMashupResourcePackage mashupResourcePackage, Guid dialect, String commandText, Boolean forColumnInfo, IMashupContext mashupContext)
at Microsoft.Mashup.Host.ProviderShared.MashupFileHost.Microsoft.Mashup.OleDbProvider.IMashupDocument.CreateEvaluator(Guid dialect, String commandText, Boolean forColumnInfo)
at Microsoft.Mashup.OleDbProvider.MashupSession.CreateRowset(Guid dialect, String commandText, Boolean forColumnInfo)
at Microsoft.Mashup.OleDbProvider.MashupCommand.CreateRowset(Boolean forColumnInfo)
at Microsoft.Mashup.OleDbProvider.TracingCommand.CreateRowset(Boolean forColumnInfo)

Stack Trace Message:
External component has thrown an exception.

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.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.RaiseErrorDialog(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)
at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.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.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Client.Excel.OleDbProvider.ExcelMashupClassFactory.TraceAndReportException(String method, Exception exception)
at Microsoft.Mashup.OleDbProvider.TracingCommand.CreateRowset(Boolean forColumnInfo)
at Microsoft.OleDb.Command.Microsoft.OleDb.ICommandText.Execute(IntPtr punkOuter, Guid& iid, DBPARAMS* pParams, DBROWCOUNT* pcRowsAffected, IntPtr& ppv)
at Microsoft.OleDb.PInvokeInterop.CommandTextTypeInfo.Execute(IntPtr objHandle, IntPtr pUnkOuter, Guid& iid, DBPARAMS* pParams, DBROWCOUNT* cRowsAffected, IntPtr& ppv)
at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsNetStandard.LoadQuery(IntPtr workbookPointer, MarshalledConnectionInfo[] connectionInfo, Boolean showDialog, NativeFillObjectType defaultFillObjectType, Boolean defaultLoadToDataModel, CommitQueryChangesCallback commitCallback, DiscardQueryChangesCallback discardCallback)
at Microsoft.Mashup.Client.Excel.Fill.PassiveFillManager.NotifyExcelOnQueryLoading(IWorkbookIdentity workbookIdentity, IEnumerable`1 addedQueries, Boolean promptForLoadOptions, FillObjectType defaultsFillObjectType, Boolean defaultAddToDataModel, CommitQueryChangesCallback commitCallback, DiscardQueryChangesCallback discardCallback)
at Microsoft.Mashup.Client.Excel.Fill.PassiveFillManager.<>c__DisplayClass3_0.<TryInitializeLoadFlow>b__2()
at Microsoft.Mashup.Client.Excel.Shim.NativeRefreshCachingServices.InvokeWithRefreshSession(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.Fill.PassiveFillManager.TryInitializeLoadFlow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, Queries queries, QueriesDiffs queriesDiffs, InitialFillTargets defaultFillTargets, QueriesCommitPoint queriesCommitPoint, IQueryServices queryServices, Action onFillStarted, Boolean promptForLoadOptions, Boolean allowExistingWorksheet, Boolean showCancelConfirmation)
at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope)
at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass12_1.<ShowModalQueriesEditorWindow>b__1(IUndoScope undoScope)
at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.<>c__DisplayClass6_0.<InvokeUndoableAction>b__0()
at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)
at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass12_0.<ShowModalQueriesEditorWindow>b__0()
at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)
at Microsoft.Mashup.Client.Excel.DialogManager.EditNewQuery(QueriesCommitPoint queriesCommitPoint, Query query, IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, JsonUpdate builderResults, Boolean isBlankQuery)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass58_1.<OnImportSuccess>b__0(IUndoScope undoScope)
at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.<>c__DisplayClass6_0.<InvokeUndoableAction>b__0()
at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)
at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.OnImportSuccess(IEnumerable`1 importedQueries, DataImportDestination destination)
at Microsoft.Mashup.Client.UI.Shared.DataImporter.ProcessImportedQueries(IEnumerable`1 importedQueries, DataImportDestination destination)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.OnTablePreviewDialogAction(Query query, TablePreviewDialogAction dialogAction)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass54_0.<ImportTextSource>b__0(IWorkbook workbook)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass55_1.<NotifyGetDataPresence>b__1()
at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass55_0.<NotifyGetDataPresence>b__0(IWorkbook workbook)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass56_0.<InvokeOnWorkbook>b__0(IWorkbook workbook, IWindowContext windowContext)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook[T](Func`3 action, T defaultValue)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook(Action`1 action)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.NotifyGetDataPresence(Action`1 action)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.ImportTextSource(Query query, PreviewResult previewResult, String formulaTitle)
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.Excel.ExcelDataImporter.<>c__DisplayClass62_0.<GetPreviewResult>b__1()
at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass62_0.<GetPreviewResult>b__0(IWorkbook workbook)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass55_1.<NotifyGetDataPresence>b__1()
at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass55_0.<NotifyGetDataPresence>b__0(IWorkbook workbook)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass56_0.<InvokeOnWorkbook>b__0(IWorkbook workbook, IWindowContext windowContext)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook[T](Func`3 action, T defaultValue)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook(Action`1 action)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.NotifyGetDataPresence(Action`1 action)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass78_1.<OnQuerySettingsResolved>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3_0.<Post>b__0(Object null)
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.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


Error Code:
-2147467259 (0x80004005)

Supports Premium Content:
True

Formulas:


section Section1;

shared #"revenue history" = let
Source = Csv.Document(File.Contents("C:\Users\O\Downloads\Support _history.csv"),[Delimiter=",", Columns=5, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Year", Int64.Type}, {"Business Year", Int64.Type}, {"Revenue ($mil)", type number}, {"Units Sold", Int64.Type}, {"Notes", type text}})
in
#"Changed Type";

 

 

Ive tried restarting, copy/paste. Not sure what to do and I have to fix this in order to complete my school assignment. 

I've recently downloaded Sims 4 onto my laptop. Could that be a reason for this error message or are the 2 not correlated?

 

Thank you, stay safe

2 Replies
Highlighted

@k_striick I would focus on one program at a time. So maybe start with CSV file. Are you trying to import a data set once or is this a spreadsheet that will continue to pull in info from an updated CSV file?

 

A bit more information on how you are building your excel file would be helpful. 

Pretty easy to go into excel, Data and import data from a CSV file.  

Highlighted

Hello, I figured it out. I had to repair my Microsot Office.