search

microsoft / botframework-solutions

Welcome to the Bot Framework Solutions repository which is the home for a set of templates and solutions to help build advanced conversational experiences using Azure Bot Service and Bot Framework. Microsoft Bot Framework is a comprehensive framework for building enterprise-grade conversational AI experiences.
https://aka.ms/bfsolutionsdocs
MIT License
1.05k stars 529 forks source link

power bi shows error when starts[Docs] #3508

Closed ashoksamal6363 closed 4 years ago

ashoksamal6363 commented 4 years ago

/solution-accelerators/tutorials/view-analytics/3-open-template/

Feedback Type: Frown (Error)

Error Message: Unrecognized JSON property: retainDataTillForceCalculate. Check path 'model.tables[13].partitions[0].retainDataTillForceCalculate', line 6874, position 43.

Stack Trace: at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title) at Microsoft.PowerBI.Client.Windows.Services.TemplateManager.TryImportTemplate(IPowerBIWindowService windowService, IQueryServices queryServices, IExceptionHandler exceptionHandler, TelemetryUserActionId entryPoint, Boolean& editQueries, String filePath) at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.ImportTemplate(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, ImportTemplateParameters parameters) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Stack Trace Message: Unrecognized JSON property: retainDataTillForceCalculate. Check path 'model.tables[13].partitions[0].retainDataTillForceCalculate', line 6874, position 43.

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.<>cDisplayClass14_0.b0() at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Practices.Prism.Commands.DelegateCommandBase.<>cDisplayClass4_0.<.ctor>b0(Object arg) at Microsoft.Practices.Prism.Commands.DelegateCommandBase.d10.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.Practices.Prism.Commands.DelegateCommandBase.Execute(Object parameter) at Microsoft.Practices.Prism.Commands.DelegateCommand`1.d5.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.Practices.Prism.Commands.DelegateCommand1.Execute(T parameter) at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand1.Execute(ICommand command, Object parameter) at Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter) at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand1.Execute(T parameter) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass1_7.<<Main>b__7>d.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass1_7.<Main>b__7(MainWindow mainWindow) at Microsoft.PowerBI.Client.Windows.MainWindow.<<ActivateMainWindow>b__203_1>d.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.MainWindow.<ActivateMainWindow>b__203_1() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func1 asyncFunc) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.d0.MoveNext() at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc) at Microsoft.PowerBI.Client.Windows.MainWindow.b203_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.<>n0(IWindowHandle owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Program.<>cDisplayClass1_0.

b1() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>cDisplayClass3_0.b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.Main(String[] args)

PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.83.5894.421","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.AnalysisServices.JsonSerializationException","MethodDef":"HandleError","ErrorOffset":"76"}

Snapshot Trace Logs: C:\Users\assamal\Microsoft\Power BI Desktop Store App\FrownSnapShot1320207347.zip

Model Default Mode: Empty

Model Version: PowerBI_V1

Is Report V3 Models Enabled: True

Performance Trace Logs: C:\Users\assamal\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features: PBI_NewWebTableInference PBI_v3ModelsPreview

Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_inlineExplore PBI_dataSearchCuration PBI_azureMapVisual

Disabled DirectQuery Options: TreatHanaAsRelationalSource

Cloud: MSIT

Formulas:

section Section1;

ryanisgrig commented 4 years ago

Thanks for the feedback! I will follow up with this after investigating.

samaea commented 4 years ago

+1

ashoksamal6363 commented 4 years ago

I solved it by uninstalling old version of powerbi and downloading the latest version of PowerBI.

ryanisgrig commented 4 years ago

Thanks @ashoksamal6363, can you share what specific version of Power BI Desktop you are using? From my testing:

Latest v2.83.5894.442 64-bit (July 2020): ERRORS with above message. Installed as a Microsoft Store app.

v2.82.5858.1161 64-bit (June 2020): SUCCESS. Installed as executable desktop application.

samaea commented 4 years ago

Uninstalled and reinstalled Power BI Desktop (Microsoft Store app v2.83.5894.442) - same error message. Installed as executable desktop app (v2.82.5858.1161), it works now. For some odd reason, I am now facing issues with authentication which I have logged here:- https://github.com/microsoft/botframework-solutions/issues/3245.

pavolum commented 4 years ago

@ryanlengel @samaea how were you able to download the v2.82.5858.1161 version. It seems the download link posted above only lets you download the 2.83.5894.442 desktop app. Is there some other portal where you can download older versions of PowerBI? I found this source https://chocolatey.org/packages/PowerBI/2.82.5858.1161#discussion but even when you add the version to the CLI command it still downloads the latest release.

pavolum commented 4 years ago

Closing this issue as it is being tracked here https://github.com/microsoft/botframework-solutions/issues/3591

Note: the link above has guidance on installing an updated template that works with the latest version of PowerBI