Power Query loading .net framework

When starting any data connection type (power query or get & transform) main windows shows "loading .NET framework" and this takes about 3 to 5 mins when excel shows a message box informing me that it's waiting for another application to start and gives me two options whether to wait or to cancel.

If I chose to cancel then another message box shows some error message with options to copy to clipboard or cancel.

BTW, when i tried Power BI Desktop it also hangs when trying to connect to data

Following is the error details after copying to clipboard:

Feedback Type:
Frown (Error)

Error Message:
Unspecified error (Exception from HRESULT: 0x80004005 (E_FAIL))

Stack Trace:
at System.Threading.Monitor.Enter(Object obj)
at Microsoft.Mashup.Host.Document.UISettings.GetSetting[T](String settingName, Func`2 getFunc)
at Microsoft.Mashup.Host.Document.UISettings.get_EnableWebTableInference()
at Microsoft.Mashup.Host.Document.ApplicationOptions.get_EnableWebTableInference()
at Microsoft.Mashup.Host.Document.FormulaRegistry.<GetBuiltInFormulas>d__1.MoveNext()
at Microsoft.Mashup.Host.Document.FormulaSet.BuiltInFormulaSet.<GetFormulas>d__1.MoveNext()
at Microsoft.Mashup.Host.Document.FormulaRegistry.<GetPotentialFormulasCore>d__19.MoveNext()
at Microsoft.Mashup.Host.Document.FormulaRegistry.<GetPotentialFormulas>d__16.MoveNext()
at Microsoft.Mashup.Host.Document.FormulaRegistry.TryGetFormula(FormulaSet formulaSet, FormulaReference formulaReference, FormulaResult baseResult, Formula& formula)
at Microsoft.Mashup.Host.Document.FormulaRegistry.GetFormula(FormulaSet formulaSet, FormulaReference formulaReference, FormulaResult baseResult)
at Microsoft.Mashup.Client.UI.Shared.DataImporter.ResolveQuerySettings(Query query, Action`2 successCallback, Action failureCallback, ResolutionSetting resolutionSetting, Boolean isNewQuery, Boolean isFromEditor)
at Microsoft.Mashup.Client.UI.Shared.DataImporter.ResolveQuerySettings(Query query, SourceFormula addedFormula, Boolean isNewQuery, Boolean isFromEditor)
at Microsoft.Mashup.Client.UI.Shared.DataImporter.TryAddSource(String sourceID, Nullable`1 targetQueryGroupId, Query& newQuery)
at Microsoft.Mashup.Client.Excel.UI.LegacyMashupClientUIServices.<>c__DisplayClass10_0.<AddQueries>b__0(IXlsActivity xlsActivity)
at Microsoft.Mashup.Client.Excel.Telemetry.XlsActivity.IXlsActivityManagerExtensions.<>c__DisplayClass1_0.<WrapWithPQDesktopActivity>b__0(IXlsActivity activity)
at Microsoft.Mashup.Client.Excel.Native.Telemetry.XlsActivityManager.WrapWithActivity[T](NativeTelemetryNamespace telemetryNamespace, String activityName, SamplingPolicy samplingPolicy, DataCategories dataCategories, String cogsReviewUrl, Func`2 activityOperation)
at Microsoft.Mashup.Client.Excel.Telemetry.XlsActivity.IXlsActivityManagerExtensions.WrapWithPQDesktopActivity(IXlsActivityManager manager, String activityName, SamplingPolicy samplingPolicy, DataCategories dataCategories, String cogsReviewUrl, Action`1 activityOperation)
at Microsoft.Mashup.Client.Excel.DialogManager.AddSource(IWindowContext windowContext, IWorkbook workbook, IQueryServices queryServices, String sourceID)
at Microsoft.Mashup.Client.Excel.ExcelRibbonHandler.<>c__DisplayClass21_1.<OnSourceButtonAction>b__1(IUndoScope undoScope)
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.Shim.IWindowContextExtensions.TryInvokeOnParentWorkbook(IWindowContext windowContext, Action`1 action)
at Microsoft.Mashup.Client.Excel.NativeRibbonHandler.<>c__DisplayClass6_0.<OnRibbonButtonAction>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Stack Trace Message:
Unspecified error (Exception from HRESULT: 0x80004005 (E_FAIL))

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, 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.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.Mashup.Client.Excel.Native.NativeExcelCallbackInvoker.InvokeAndReturnHResult(Action action)

Error Code:
-2147467259 (0x80004005)

Supports Premium Content:
True

Formulas:

section Section1;

shared Query1 = let
Source = ""
in
Source;