none
Unable to create specified ActiveX control RRS feed

  • Question

  • Close & Load Option in Power Query not working. It is always throwing error.
    ------------------------------

    --------------------
    Please provide a complete description above.


    Data to send to Microsoft:

    Feedback Type:
    Frown (Error)

    Timestamp:
    2017-04-26T18:00:05.5522731Z

    Local Time:
    2017-04-26T23:30:05.5522731+05:30

    Product Version:
    2.43.4647.201 (PQ-CY17SU02) (x64)

    Release:
    January 2017

    Excel Version:
    15.0.4919.1000

    Excel Install Location:
    C:\Program Files\Microsoft Office\Office15\EXCEL.EXE

    IE Version:
    11.1066.14393.0

    OS Version:
    Microsoft Windows NT 10.0.14393.0 (x64 en-US)

    CLR Version:
    4.6.2. or later [Release Number = 394802]

    Workbook Package Info:
    1* - en-IN, fastCombine: Disabled, runBackgroundAnalysis: True.

    Peak Working Set:
    340 MB

    Private Memory:
    295 MB

    Peak Virtual Memory:
    34 GB

    Screenshot:


    Error Message:
    Unable to create specified ActiveX control.

    Stack Trace:
    Microsoft.Mashup.Client.ClientShared.Com.ComWrapperException: Unable to create specified ActiveX control. ---> System.Runtime.InteropServices.COMException: Unable to create specified ActiveX control.
    --- End of inner exception stack trace ---
    at Microsoft.Mashup.Client.ClientShared.Com.ComWrapper.InvokeMember(String memberName, BindingFlags bindingFlags, Object[] args)
    at Microsoft.Mashup.Client.Excel.Com.CTPFactory.CreateCTP(String axID, String title, IWindow parentWindow)
    at Microsoft.Mashup.Client.Excel.Shim.AddInTaskPaneServices.TryCreateCustomTaskPane(TaskPaneType taskPaneType, ExcelWindowId excelWindowId, IWindow comWindow, Int32 initialWidth, ICustomTaskPane& customTaskPane)
    at Microsoft.Mashup.Client.Excel.Shim.AddInTaskPaneServices.TryCreateCustomTaskPane(TaskPaneType taskPaneType, IWindowContext windowContext, Int32 intitialWidth, ITaskPane& taskPane)
    at Microsoft.Mashup.Client.Excel.CustomTaskPaneManager.TryCreateTaskPane(IWindowContext windowContext, ITaskPane& taskPane)
    at Microsoft.Mashup.Client.Excel.QueriesTaskPaneManagerBase.TryShowTaskPane(IWindowContext windowContext)
    at Microsoft.Mashup.Client.Excel.DialogManager.TryShowQueriesTaskPane()
    at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass2.<ShowModalQueriesEditorWindow>b__0()
    at Microsoft.Mashup.Client.Excel.PollingFillManager.TryInitializeLoadFlow(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, Queries queries, QueriesDiffs queriesDiffs, HashSet`1 loadToIgnoredQueries, InitialFillTargets defaultFillTargets, QueriesCommitPoint queriesCommitPoint, IQueryServices queryServices, Action onFillStarted, Boolean promptForLoadOptions, Boolean allowExistingWorksheet, Boolean showCancelConfirmation)
    at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.OnImportSuccess(IEnumerable`1 importedQueries, DataImportDestination destination)
    at Microsoft.Mashup.Client.ClientShared.DataImporter.ProcessImportedQueries(IEnumerable`1 importedQueries, DataImportDestination destination)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.ImportTextSource(Query query, PreviewResult previewResult, String formulaTitle)
    at Microsoft.Mashup.Client.ClientShared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
    at Microsoft.Mashup.Client.ClientShared.DataImporter.<>c__DisplayClass1e.<OnQuerySettingsResolved>b__1b()
    at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

    Invocation Stack Trace:
    at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
    at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
    at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
    at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
    at Microsoft.Mashup.Client.ClientShared.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)


    User ID:
    c388265e-bd99-438b-9c59-73ae93b3deed

    Supports Premium Content:
    True

    Telemetry Enabled:
    True

    DPI Scale:
    100%

    Formulas:


    section Section1;

    shared Onetable123 = let
    Source = Csv.Document(File.Contents("C:\Users\Ankur\Desktop\Analyzing-Visualizing-Data-Excel-master\Analyzing-Visualizing-Data-Excel-master\Module3\Module_3_onetable\Onetable123.csv"),[Delimiter=",", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"ProductID", Int64.Type}, {"Segment", type text}}),
    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed Type",1)
    in
    #"Removed Bottom Rows";

    Thursday, April 27, 2017 9:48 AM

Answers