lFahadl's avatar
lFahadl
Frequent Visitor
2 years ago
Status:
Investigating

Power BI Desktop don't work

Hello,

I hope good health

I have a problem with the app working after the February update

 

Feedback Type:
Frown (Error)

Timestamp:
2024-03-17T06:31:58.0559452Z

Local Time:
2024-03-17T09:31:58.0559452+03:00

Session ID:
31924743-56b1-4b96-aa41-318f4fc03cd9

Release:
February 2024

Product Version:
2.126.1261.0 (24.02) (x64)

Stack Trace:
System.NullReferenceException
at Microsoft.Mashup.DocumentServices.Shorthand.ShorthandManager.ValueIsCompatibleWithOptions(IValue value, ShorthandOptions options)
at Microsoft.Mashup.DocumentServices.Shorthand.ShorthandManager.TryGetShorthand(IValue value, IValueRoundTripStringProvider valueRoundtripStringProvider, String& shorthand, ShorthandOptions options)
at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeParameterInfo.GetDefaultSampleValues(IEngine engine, TypeHandle paramType)
at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeParameterInfo.CreateSampleValues(IEngine engine, GenericInvokeParameterInfo paramInfo, ITypeValue paramType)
at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeParameterInfo.Create(IEngine engine, GenericInvokeDetails formula, IFunctionTypeValue funcType, Int32 paramIndex)
at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeDetails.TryGetParameterInfos(GenericInvokeParameterInfo[]& parameterInfos)
at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeDetails.ProcessBaseResult(FormulaResult baseResult)
at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeDetails..ctor(IEngine engine, IFunctionTypeValue functionType, NativeQueryProperties nativeQueryProperties)
at Microsoft.Mashup.Host.Document.Formulas.GenericSourceInvokeFormula..ctor(IEngine engine, IFunctionTypeValue functionType, String functionName, String moduleName, FormulaData formulaData, String buttonTitle, String buttonHelp, Boolean isInternal, Boolean supportsDirectQuery, MultiDimensionalStyle style, NativeQueryProperties nativeQueryProperties)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.PublishedFunction.<>c__DisplayClass89_0.<GetCreator>b__0(IEngine engine)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.DataSourceFormula..ctor(String functionName, Func`2 formulaCreator, TelemetryUserActionId formulaTelemetry, Action enable, String functionButtonTitle, String iconClass)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.LoadMExtensionExports(IList`1 modules)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.TracePerformance(Trace trace, String name, Action action)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.Activate(IList`1 libraryExtensions, IApplicationPaths applicationPaths, ILibraryProvider internalProvider, ILibraryProvider remoteExtensionsProvider)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHostManager.RegisterAndActivateUiExtensionHost(UiExtensionHost uiExtensionHost, IList`1 libraryExtensions, IApplicationPaths applicationPaths, ILibraryProvider internalProvider, ILibraryProvider remoteExtensionsProvider)
at Microsoft.PowerBI.Client.Windows.PowerQueryExtensionsLoader.<Load>b__10_1()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.126.1261.0","ModuleName":"Microsoft.Mashup.DocumentServices.dll","Component":"Microsoft.Mashup.DocumentServices.Shorthand.ShorthandManager","Error":"System.NullReferenceException","MethodDef":"ValueIsCompatibleWithOptions","ErrorOffset":"10","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.22000.0 (x64 ar-SA)

CLR Version:
4.8 or later [Release Number = 533325]

Peak Virtual Memory:
70.4 GB

Private Memory:
492 MB

Peak Working Set:
1.08 GB

IE Version:
11.1.22000.0

User ID:
c86ff492-468e-4f30-a69b-88fc2cbde24b

Workbook Package Info:
1* - ar-SA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_backstageUI
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_generateMeasureDescriptionsButton

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_tmdlInDataset
PBI_EimLessElevatedUser
PBI_modelExplorer
PBI_daxQueryView
PBI_aiNarrativesVisual
PBI_qnaImproveLsdlCopilot
PBI_visualCalculationsAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

2 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi lFahadl ,

     

    Can you describe the exact scenario in which the problem occurs so that we can reproduce your issue?
    Is this the latest version of Power BI Desktop?

     

    Best regards.
    Community Support Team_Caitlyn

  • I have same problem

     

    Feedback Type:
    Frown (Error)

    Error Message:
    Erro

    Stack Trace:
    Microsoft.Mashup.Client.UI.Shared.ExceptionResultException
    em Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
    em Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.Container.OnException(IMessageChannel channel, ExceptionMessage message)
    em Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClass3_0`1.<AddHandler>b__0(IMessageChannel channel, Message message)
    em Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    em Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    em Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    em Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    em Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
    em Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
    em Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
    em Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
    em Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
    em Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
    em Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
    em Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
    em Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
    em Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
    em Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

    Stack Trace Message:
    Erro

    Invocation Stack Trace:
    em Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
    em Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
    em Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
    em Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
    em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
    em Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
    em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
    em Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
    em Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)
    em Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
    em Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
    em Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass89_0.<OnQuerySettingsResolved>b__0()
    em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
    em Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass5_0.<Post>b__0(Object null)
    em System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
    em System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
    em System.Delegate.DynamicInvokeImpl(Object[] args)
    em System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
    em System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
    em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
    em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
    em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
    em System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
    em System.Windows.Forms.Control.InvokeMarshaledCallbacks()
    em System.Windows.Forms.Control.WndProc(Message& m)
    em System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
    em System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
    em System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
    em System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
    em System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
    em System.Windows.Forms.Application.RunDialog(Form form)
    em System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
    em Microsoft.PowerBI.Client.Windows.MainWindow.<ShowModal>b__48_0()
    em Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
    em Microsoft.PowerBI.Client.Windows.MainWindow.ShowModal(PowerBIAutomationTest powerBIAutomationTest, MainWindowParameters parameters)
    em Microsoft.PowerBI.Client.Program.<>c__DisplayClass7_0.<RunApplicationLegacy>b__0()
    em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
    em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
    em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleExceptionsWithNestedTasks(IExceptionHandler exceptionHandler, Action action)
    em Microsoft.PowerBI.Client.Program.RunApplicationLegacy(String[] args)
    em Microsoft.PowerBI.Client.Program.Main(String[] args)


    PowerBINonFatalError:
    {"AppName":"PBIDesktop","AppVersion":"2.128.1380.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Client.UI.Shared.ExceptionResultException","MethodDef":"OnException","ErrorOffset":"","ErrorCode":""}

    Snapshot Trace Logs:
    C:\Users\user\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot22093fb0-f751-4c55-ac60-729ba758d8e2.zip

    Model Default Mode:
    Empty

    Model Version:
    PowerBI_V1

    Performance Trace Logs:
    C:\Users\user\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

    Enabled Preview Features:
    PBI_sparklines
    PBI_scorecardVisual
    PBI_NlToDax
    PBI_fieldParametersSuperSwitch
    PBI_angularRls
    PBI_backstageUI
    PBI_setLabelOnExportPdf
    PBI_dynamicFormatString
    PBI_oneDriveSave
    PBI_oneDriveShare
    PBI_gitIntegration
    PBI_newCard
    PBI_buttonSlicerAuthoring
    PBI_mobileAutoReportLayout
    PBI_daxQueryView
    PBI_daxInlineCopilot
    PBI_aiNarrativesVisual
    PBI_generateMeasureDescriptionsButton
    PBI_desktopReportAuthoringCopilot

    Disabled Preview Features:
    PBI_shapeMapVisualEnabled
    PBI_SpanishLinguisticsEnabled
    PBI_qnaLiveConnect
    PBI_b2bExternalDatasetSharing
    PBI_enhancedTooltips
    PBI_onObject
    PBI_useModernPublishDialogs
    PBI_tmdlInDataset
    PBI_EimLessElevatedUser
    PBI_modelExplorer
    PBI_qnaImproveLsdlCopilot
    PBI_visualCalculationsAuthoring

    Disabled DirectQuery Options:
    TreatHanaAsRelationalSource

    Cloud:
    GlobalCloud

    ExceptionResultMessage:
    Já existe uma entrada com a mesma chave.

    PowerBIUserFeedbackServices_IsReported:
    True

    Formulas:


    section Section1;

    shared Consulta1 = let
    Fonte = MySQL.Database("localhost", "sgmr", [ReturnSingleDatabase=true])
    in
    Fonte;