Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Power BI report not opening

Can someone please urgently assist with the below error I'm getting when I try to open my Power BI report? I've been working on this report for weeks and need to publish it tomorrow but now I can't open it after I saved and closed it earlier today.
Not enough memory in the memory stream to read Xpress9 data segment. Header indicated 1989330 bytes but could read 438046. Possibly received truncated data.
 
tsupra_0-1711548670810.png

 

Feedback Type: Frown (Error) Timestamp: 2024-03-27T14:04:42.2451085Z Local Time: 2024-03-27T16:04:42.2451085+02:00 Session ID: 01b0a359-8e5f-4622-a0d5-8631170d5467 Release: March 2024 Product Version: 2.127.1080.0 (24.03) (x64) Stack Trace: Microsoft.PowerBI.Client.Windows.Storage.FileOpenException at Microsoft.PowerBI.Client.Windows.Services.LocalAnalysisServicesDatabaseCreator.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.AnalysisServicesDatabaseCreatorFactory.d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.ReportFactory.d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.BiPackageOperationHandler.d__24.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.CurrentArtifactManager.d__48.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.CurrentArtifactManager.<>c__DisplayClass33_0.<b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c__DisplayClass13_0`1.<b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion[T](Task`1 task) at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod) at Microsoft.PowerBI.Client.Windows.Services.CurrentArtifactManager.OpenArtifactAndSetAsCurrent(IPowerBIWindowService windowService, IPowerBIArtifact artifactToOpen, IExceptionHandler exceptionHandler, Nullable`1 entryPoint) at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.d__47.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.d__1.MoveNext() PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.127.1080.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Services.LocalAnalysisServicesDatabaseCreator+d__6","Error":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenException","MethodDef":"MoveNext - PFE_XPRESS9_DECOMPRESS_NOT_ENOUGH_DATA_IN_MEMSTREAM_DATA","ErrorOffset":"508","ErrorCode":"DataModelLoadFailed"} InnerException0.Stack Trace: at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.ExecuteXmla(String xmla) at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.ImageLoadDatabaseFromPbix(String databaseName, String filePath, Uri dataModelPath) at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.LoadDatabaseFromPbix(String filePath, Uri dataModelPath) at Microsoft.PowerBI.Client.Windows.Services.LocalAnalysisServicesDatabaseCreator.d__6.MoveNext() OS Version: Microsoft Windows NT 10.0.19044.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 528372] Peak Virtual Memory: 70.6 GB Private Memory: 663 MB Peak Working Set: 1.01 GB IE Version: 11.789.19041.0 User ID: 4b6f882c-175a-4575-984f-f1e4cb46cebb Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Empty Model Version: PowerBI_V1 Enabled Preview Features: PBI_shapeMapVisualEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_sparklines PBI_scorecardVisual PBI_NlToDax PBI_fieldParametersSuperSwitch PBI_angularRls PBI_backstageUI PBI_setLabelOnExportPdf PBI_dynamicFormatString PBI_oneDriveSave PBI_oneDriveShare PBI_useModernPublishDialogs PBI_gitIntegration PBI_newCard PBI_buttonSlicerAuthoring PBI_mobileAutoReportLayout PBI_daxQueryView PBI_daxInlineCopilot PBI_aiNarrativesVisual PBI_generateMeasureDescriptionsButton Disabled Preview Features: PBI_SpanishLinguisticsEnabled PBI_enhancedTooltips PBI_onObject PBI_tmdlInDataset PBI_EimLessElevatedUser PBI_modelExplorer PBI_qnaImproveLsdlCopilot PBI_visualCalculationsAuthoring Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI

Status: Investigating

Hi @tsupra ,

 

Based on the error message above, please make sure that no other memory-intensive applications are running on your computer. Close any unnecessary programs to free up memory. If possible, consider upgrading your computer’s RAM or closing other applications to increase available memory.
If your report contains a large amount of data, consider optimizing your data model. You can reduce the amount of data being loaded into Power BI Desktop.If your report file or data source isn’t corrupted. If it is, try repairing it or restoring it from a backup.

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @tsupra ,

 

Based on the error message above, please make sure that no other memory-intensive applications are running on your computer. Close any unnecessary programs to free up memory. If possible, consider upgrading your computer’s RAM or closing other applications to increase available memory.
If your report contains a large amount of data, consider optimizing your data model. You can reduce the amount of data being loaded into Power BI Desktop.If your report file or data source isn’t corrupted. If it is, try repairing it or restoring it from a backup.

 

Best regards.
Community Support Team_Caitlyn