Publish to powerbi service fails intermittently. Today is worse. Here is the error log: Feedback Type: Frown (Error) Timestamp: 2019-02-28T16:02:14.4182049Z Local Time: 2019-02-28T16:02:14.4182049+00:00 Session ID: 5925ee53-b710-49db-afd7-5d095a92f1ea Release: February 2019 Product Version: 2.66.5376.2521 (19.02) (x64) Error Message: We’re sorry, a problem occurred while connecting to Power BI service. Please try again. Stack Trace: at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo.GetCurrent() at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail) at Microsoft.PowerBI.Client.Windows.PowerBIService.ReportPublisher.<PromptPublishToGroupDialog>d__16.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.PowerBIService.ReportPublisher.PromptPublishToGroupDialog(IPowerBIWindowService windowService, TelemetryUserActionId entryPoint, IPowerBIServicePublishProperties pbiBiServicePublishProperties, CancellationTokenSource cancellationTokenSource, Boolean requiresPremiumWorkspace) at Microsoft.PowerBI.Client.Windows.PowerBIService.ReportPublisher.<PublishReport>d__13.MoveNext() 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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run() at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask) at System.Threading.Tasks.Task.FinishContinuations() at System.Threading.Tasks.Task`1.TrySetResult(TResult result) at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetResult(TResult result) at Microsoft.PowerBI.Client.Windows.PowerBIService.ReportPublisher.<TryEnsureFileIsSavedBeforePublish>d__15.MoveNext() 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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run() at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask) at System.Threading.Tasks.Task.FinishContinuations() at System.Threading.Tasks.Task`1.TrySetResult(TResult result) at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetResult(TResult result) at Microsoft.PowerBI.Client.Windows.Services.ReportManager.<IsReportDirty>d__24.MoveNext() 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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run() at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask) at System.Threading.Tasks.Task.FinishContinuations() at System.Threading.Tasks.Task`1.TrySetResult(TResult result) at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetResult(TResult result) at Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowserBase.<InvokeScriptAsync>d__23`1.MoveNext() 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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run() 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) Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo.GetCurrent() at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail) at Microsoft.PowerBI.Client.Windows.PowerBIService.ReportPublisher.<PromptPublishToGroupDialog>d__16.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.PowerBIService.ReportPublisher.PromptPublishToGroupDialog(IPowerBIWindowService windowService, TelemetryUserActionId entryPoint, IPowerBIServicePublishProperties pbiBiServicePublishProperties, CancellationTokenSource cancellationTokenSource, Boolean requiresPremiumWorkspace) at Microsoft.PowerBI.Client.Windows.PowerBIService.ReportPublisher.<PublishReport>d__13.MoveNext() 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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run() at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask) at System.Threading.Tasks.Task.FinishContinuations() at System.Threading.Tasks.Task`1.TrySetResult(TResult result) at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetResult(TResult result) at Microsoft.PowerBI.Client.Windows.PowerBIService.ReportPublisher.<TryEnsureFileIsSavedBeforePublish>d__15.MoveNext() 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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run() at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask) at System.Threading.Tasks.Task.FinishContinuations() at System.Threading.Tasks.Task`1.TrySetResult(TResult result) at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetResult(TResult result) at Microsoft.PowerBI.Client.Windows.Services.ReportManager.<IsReportDirty>d__24.MoveNext() 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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run() at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask) at System.Threading.Tasks.Task.FinishContinuations() at System.Threading.Tasks.Task`1.TrySetResult(TResult result) at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetResult(TResult result) at Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowserBase.<InvokeScriptAsync>d__23`1.MoveNext() 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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run() 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) OS Version: Microsoft Windows NT 10.0.17763.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 461814] Peak Virtual Memory: 38.4 GB Private Memory: 792 MB Peak Working Set: 944 MB IE Version: 11.316.17763.0 User ID: f72cd5db-b354-451f-a0e6-5b218567127d Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: Import Snapshot Trace Logs: C:\Users\maganti\Microsoft\Power BI Desktop Store App\FrownSnapShot952310116.zip Performance Trace Logs: C:\Users\maganti\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip Disabled Preview Features: PBI_shapeMapVisualEnabled MIntellisense PBI_SpanishLinguisticsEnabled PBI_PdfImport PBI_ColumnProfiling PBI_variationUIChange PBI_PythonSupportEnabled PBI_showIncrementalRefreshPolicy PBI_showManageAggregations PBI_FuzzyMatching PBI_EnableWebDiagramView PBI_improvedFilterExperience PBI_qnaLiveConnect PBI_keyDrivers Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI Formulas: section Section1; shared ProductMaster = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _ProductMaster = Source{[Schema="",Item="ProductMaster"]}[Data] in _ProductMaster; shared DimCustomer = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimCustomer = Source{[Schema="",Item="DimCustomer"]}[Data] in _DimCustomer; shared DimDate = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimDate = Source{[Schema="",Item="DimDate"]}[Data] in _DimDate; shared DimGeography = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimGeography = Source{[Schema="",Item="DimGeography"]}[Data], #"Added Conditional Column" = Table.AddColumn(_DimGeography, "BusinessRegion", each if [EnglishCountryRegionName] = "Australia" then "APAC" else if [EnglishCountryRegionName] = "Canada" then "AMERICAS" else if [EnglishCountryRegionName] = "France" then "EU" else if [EnglishCountryRegionName] = "United Kingdom" then "EU" else if [EnglishCountryRegionName] = "Germany" then "EU" else if [EnglishCountryRegionName] = "United States" then "AMERICAS" else "UNKNOWN") in #"Added Conditional Column"; shared DimProduct = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimProduct = Source{[Schema="",Item="DimProduct"]}[Data] in _DimProduct; shared DimProductCategory = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimProductCategory = Source{[Schema="",Item="DimProductCategory"]}[Data] in _DimProductCategory; shared DimProductSubCategory = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimProductSubCategory = Source{[Schema="",Item="DimProductSubCategory"]}[Data] in _DimProductSubCategory; shared DimPromotion = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimPromotion = Source{[Schema="",Item="DimPromotion"]}[Data] in _DimPromotion; shared DimSalesTerritory = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimSalesTerritory = Source{[Schema="",Item="DimSalesTerritory"]}[Data] in _DimSalesTerritory; shared FactInternetSales = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _FactInternetSales = Source{[Schema="",Item="FactInternetSales"]}[Data] in _FactInternetSales; shared DimOrderDate = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimDate = Source{[Schema="",Item="DimDate"]}[Data], #"Renamed Columns" = Table.RenameColumns(_DimDate,{{"DateKey", "OrderDateKey"}}) in #"Renamed Columns"; shared DimShipDate = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimDate = Source{[Schema="",Item="DimDate"]}[Data], #"Renamed Columns" = Table.RenameColumns(_DimDate,{{"DateKey", "ShipDateKey"}}) in #"Renamed Columns"; shared DimDueDate = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\BookData.accdb"), [CreateNavigationProperties=true]), _DimDate = Source{[Schema="",Item="DimDate"]}[Data], #"Renamed Columns" = Table.RenameColumns(_DimDate,{{"DateKey", "DueDateKey"}}) in #"Renamed Columns"; shared Bookings = let Source = Access.Database(File.Contents("C:\Users\maganti\Desktop\power\bookfiles_2013\Ch20_PowerQuery\DataAndLookupTogether.accdb"), [CreateNavigationProperties=true]), _Bookings = Source{[Schema="",Item="Bookings"]}[Data] in _Bookings;
... View more