Unerwarteter Fehler im Power Query Fenster: Container wurde unerwartet mit Code 0xC0000005 beendet
Unerwarteter Fehler im Power Query Fenster: Feedback Type: Frown (Error) Timestamp: 2025-03-21T10:25:43.1722787Z Local Time: 2025-03-21T11:25:43.1722787+01:00 Session ID: ... Release: February 2025 Product Version: 2.140.1577.0 (25.02)+... (x64) Error Message: Der Container wurde unerwartet mit Code 0xC0000005 beendet. PID: 4568. Verwendete Funktionen: (Keine). Stack Trace: Microsoft.Mashup.Host.Document.SerializedException bei Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read() bei Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel) bei Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read() bei Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel) bei Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing) bei Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource() bei Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource() bei Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled) Stack Trace Message: Der Container wurde unerwartet mit Code 0xC0000005 beendet. PID: 4568. Verwendete Funktionen: (Keine). Invocation Stack Trace: bei Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() bei Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage) bei Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e) bei Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture) bei Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0() bei Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e) bei Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) bei System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) bei System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) bei System.Delegate.DynamicInvokeImpl(Object[] args) bei System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) bei System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) bei System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) bei System.Windows.Forms.Control.InvokeMarshaledCallbacks() bei System.Windows.Forms.Control.WndProc(Message& m) bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) bei System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) bei System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) bei System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) bei System.Windows.Forms.Form.ShowDialog(IWin32Window owner) bei Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) bei Microsoft.PowerBI.Client.Program.<>c__DisplayClass7_0.<RunApplicationLegacy>b__0() bei Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() bei Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) bei Microsoft.PowerBI.Client.Program.RunApplicationLegacy(String[] args, IPowerBIRootTrace trace) bei Microsoft.PowerBI.Client.Program.Main(String[] args) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.140.1577.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Host.Document.Evaluation.ErrorEvaluationResult","MethodDef":"Read","ErrorOffset":"","ErrorCode":""} OS Version: Microsoft Windows NT 10.0.22631.0 (x64 de-DE) CLR Version: 4.8 or later [Release Number = 533320] Peak Virtual Memory: 72.5 GB Private Memory: 1.44 GB Peak Working Set: 2.32 GB IE Version: 11.1.22621.0 User ID: ... Workbook Package Info: 1* - de-DE, Query Groups: 7, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: False Snapshot Trace Logs: ... Model Default Mode: Import Model Version: PowerBI_V3 Performance Trace Logs: ... Enabled Preview Features: PBI_sparklines PBI_scorecardVisual PBI_fieldParametersSuperSwitch PBI_setLabelOnExportPdf PBI_oneDriveSave PBI_oneDriveShare PBI_useModernPublishDialogs PBI_gitIntegration PBI_tmdlInDataset PBI_directLakeRemoteModeling PBI_newCard PBI_buttonSlicerAuthoring PBI_EimLessElevatedUser PBI_mobileAutoReportLayout PBI_daxInlineCopilot PBI_aiNarrativesVisual PBI_generateMeasureDescriptionsButton PBI_visualCalculationsAuthoring PBI_desktopReportAuthoringCopilot Disabled Preview Features: PBI_snowflakeAdbcVersionEnabled PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_metricsArtifactsOnDesktop PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_onObject PBI_odspSaveBackgroundUpload PBI_modernOfficeFilePicker PBI_publishDialogsSupportSubfolders PBI_enhancedReportFormat PBI_advancedSlicerTypeList PBI_textSlicer PBI_qnaImproveLsdlCopilot PBI_tmdlViewToggle PBI_UserInstalledVerticaODBCDriver Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud PowerBINonFatalError_ErrorDescription: Microsoft.Mashup.Host.Document.Evaluation.ErrorEvaluationResult PowerBIUserFeedbackServices_IsReported: True DPI Scale: 100% Supported Services: Power BI Formulas: ...
Incremental Refresh Overlapping/Duplication of Rows
Dear Team, I am facing an issue with the incremental refresh, when I am opting for incremental refresh starting from one month before the refresh date, the data of the first day of the month is twice the actual value. Example : When I opt for this setting, the data of first of March is twice the actual value, no matter the how many refresh has been done. And all the data afterwards that particular date is correct though. Below is the screenshot of the parameter settings and the m-query. Please do support with a possible solution for the issue.Cannot take over Gen2 dataflow
When attempting to open a Gen2 dataflow owned by someone else, I get the below message: If I try to access the settings for that dataflow: I am an admin on the workspace this dataflow is in, and the issue does not happen with Gen1 dataflows. Inconsistent messaging and imo this is a bug.
Passing (sliced) data to R and then retrieving output object back to Powerbi
I have an application where I have a large dataset in POwerBI and I need to select subsets via slicers (easy) and then pass that subset to R (also easy). Then, for example, I want to run a regression and return a dataframe of coefficients and standard errors back to PowerBI for display not as a visual but in data for presentation in cards/tables, etc. It is easy to subset the data, easy to pass the subset to R, easy to Run (say lm) on that subset and easy to generate a rectangular table of beta estimates an SE (via tidyr::broom), but how do I get the broom-generated output object back into powerBI in real time? I do not want a visual from R, I want data.Direct Lake Mode error: "Class: 'ParquetException' Status: 'Unexpected end of stream'"
Hello, I have created a star schema using the TPCH10 benchmark dataset in two separate Power BI datasets: one uses import mode and one uses direct lake mode. The model is below. Fact_orders has ~60M records and Fact_orders[l_extendedprice] is a decimal column. Two separate thin reports have been created in PBI desktop, one connecting to each model in PBI service. When Fact_orders[l_extendedprice] is summed via a card visual in a report based on import mode dataset, the visual renders successfully. When the same visual is created in a report based on the the direct lake dataset, the visual fails to render with the following message: "Unexpected parquet exception occurred. Class: 'ParquetException' Status: 'Unexpected end of stream'" The same error appears in other scenarios when using the direct lake mode dataset. For example, if a card visual used to count the rows in the fact_orders table, the visual successfully renders the correct value (~60M). However, if a filter is added to the report using dim_customer[c_mktsegment], the visual fails to render with the same error. Below is a screenshot of the error when the filter query is evaluated in TE3. Please let me know if you need additional information. Thanks!Custom connector: refresh without clearing cache often leads to 'The key didn't match any rows'
We have created a Power BI custom connector that connects to our webservice. The connector works with a nested folder structure. The user selects one or more tables from one or more folders. Part of the connector's structure (folder and table names) is fixed, while other parts are dynamic (depend on the data the user has in their webservice). The problem which our users experience, is that they often have to clear the cache in Power BI Desktop for a refresh to work successfully. If they don't clear the cache, they get an error saying: 'The key didn't match any rows in the table'. To our best knowledge, this error means that Power BI cannot find the table with the given name and folder-path. However, this error also occurs if a user refreshes a (report created with a) table that has a fixed name and path, in which case this error seems to not apply. Is this a known issue? Is there a fix or workaround (other than clearing the cache each time before a refresh)? Is it indeed caused by the custom connector's structure being partly dynamic? Any help is greatly appreciated!
Data error on eTMF Governance Dashboard
Hi team, Yesterday I was checking the timeliness rate of our study D933YC00001, and found that it was 69.6%, and there were 17 overdue documents. After exporting the VCV report according to the guide below, I found that these 17 docuements included country and site level, but in fact I only ticked those who have chosen study level, please help me to confirm if the system data is wrong, and can you correct it as soon as possible?Reordering non-table queries in a DataMart generates an invalid query.
I have a table which has two simialar steps. It calcualets the max of one column, then adds a row which is value of each row divided by the max. I then do the same with a second column. For example, my query looks a little like this: let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTJXitWJVjICsiyUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [a = _t, b = _t]), #"Changed column type" = Table.TransformColumnTypes(Source, {{"a", Int64.Type}, {"b", Int64.Type}}), MaxA = Record.Field(Table.Max(#"Changed column type", "a"), "a"), #"A percent" = Table.TransformColumnTypes(Table.AddColumn(#"Changed column type", "A percent", each [a] / MaxA), {{"A percent", type number}}), MaxB = Record.Field(Table.Max(#"A percent", "b"), "b"), #"B percent" = Table.TransformColumnTypes(Table.AddColumn(#"A percent", "B percent", each [b] / MaxB), {{"B percent", type number}}) in #"B percent" Which renders like this: I decided I woud like to group the calculations for an easier read, so I drag and drop MaxB to be above A percent, grouping the max calculations and percentage calculations: However, this generates broken M: let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTJXitWJVjICsiyUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [a = _t, b = _t]), #"Changed column type" = Table.TransformColumnTypes(Source, {{"a", Int64.Type}, {"b", Int64.Type}}), MaxA = Record.Field(Table.Max(#"Changed column type", "a"), "a"), MaxB = Record.Field(Table.Max(MaxA, "b"), "b"), #"A percent" = Table.TransformColumnTypes(Table.AddColumn(#"Changed column type", "A percent", each [a] / MaxB), {{"A percent", type number}}), #"B percent" = Table.TransformColumnTypes(Table.AddColumn(MaxA, "B percent", each [b] / #"A percent"), {{"B percent", type number}}) in #"B percent" Notice that the MaxB calculation now refers to the non-tabular data MaxA, and the B percent column is trying to add a column to the same non-tabular item.
Duplicate Value
Evething is okay until yesterday but I got an refresher error this morning. It said that FACT_ORDERS table contains a duplicate value, so I go to the database and write a simple query to check: there are no duplicate values showing. I found the solution in PBI Community (use Remove Duplicates in Power Query) but I really want to know what caused this issue. Does anyone know? Thanks!
