Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

0
shashankdeep

PowerBI Desktop file is corrupted, after installed the the november version

Submitted by on ‎12-05-2023 01:49 AM

Feedback Type:
Frown (Error)

Error Message:
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1.PwCCountryList (97429).RowNumber 2662979B 1795 4F74 8F37 6A1BA8059B61 (97430).0.idf'. (PwCCountryList (97429)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '7.H$Table (97144)$Column (97374).ID_TO_POS.0.idf'. (H$Table (97144)$Column (97374)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '0.H$Table (97144)$User Email (97196).POS_TO_ID.0.idf'. (H$Table (97144)$User Email (97196)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '8.Table (97144).Column (97374).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '5.License User Service Plan (94461).Column (95155).0.idf'. (License User Service Plan (94461)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '0.License User Service Plan (94461).UserUID (94473).0.idf'. (License User Service Plan (94461)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '3.Table (97144).User Country Code (97198).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '3.Table (97144).User Email (97196).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '3.Table (97144).UserIsExternal (97283).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '3.Table (97144).User UID (97194).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
An error occurred while loading Vertipaq data objects for multiple tables.


Stack Trace:
Microsoft.PowerBI.Client.Windows.Storage.FileOpenException
at Microsoft.PowerBI.Client.Windows.Services.AnalysisServicesDatabaseFactory.<PerformDataModelParseAction>d__11`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.AnalysisServicesDatabaseFactory.<CreateAnalysisServicesDatabaseAsync>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at Microsoft.PowerBI.Client.Windows.Services.ReportFactory.<CreateReportFromPowerBIStorage>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.<Open>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.BiPackageOperationHandler.<LoadPbiFile>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.CurrentFileManager.<ExecuteAndHandleFileOpenErrors>d__36.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.CurrentFileManager.<>c__DisplayClass23_0.<<OpenFileAndSetAsCurrent>b__1>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c__DisplayClass13_0`1.<<BlockUIAndRun>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
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.CurrentFileManager.OpenFileAndSetAsCurrent(IPowerBIWindowService windowService, IPowerBIFile fileToOpen, Nullable`1 entryPoint)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, ICurrentFileManager currentFileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Stack Trace Message:
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1.PwCCountryList (97429).RowNumber 2662979B 1795 4F74 8F37 6A1BA8059B61 (97430).0.idf'. (PwCCountryList (97429)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '7.H$Table (97144)$Column (97374).ID_TO_POS.0.idf'. (H$Table (97144)$Column (97374)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '0.H$Table (97144)$User Email (97196).POS_TO_ID.0.idf'. (H$Table (97144)$User Email (97196)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '8.Table (97144).Column (97374).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '5.License User Service Plan (94461).Column (95155).0.idf'. (License User Service Plan (94461)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '0.License User Service Plan (94461).UserUID (94473).0.idf'. (License User Service Plan (94461)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '3.Table (97144).User Country Code (97198).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '3.Table (97144).User Email (97196).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '3.Table (97144).UserIsExternal (97283).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '3.Table (97144).User UID (97194).0.idf'. (Table (97144)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
An error occurred while loading Vertipaq data objects for multiple tables.


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.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleExceptionsWithNestedTasks(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.RunApplication(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)


PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.123.742.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Services.AnalysisServicesDatabaseFactory+<PerformDataModelParseAction>d__11`1","Error":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenException","MethodDef":"MoveNext - PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA","ErrorOffset":"198","ErrorCode":"DataModelLoadFailed"}

InnerException0.Stack Trace Message:
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1.PwCCountryList (97429).RowNumber 2662979B 1795 4F74 8F37 6A1BA8059B61 (97430).0.idf'. (PwCCountryList (97429)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '7.H$Table (97144)$Column (97374).ID_TO_POS.0.idf'. (H$Table (97144)$Column (97374)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '0.H$Table (97144)$User Email (97196).POS_TO_ID.0.idf'. (H$Table (97144)$User Email (97196)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.

shashankdeep_0-1701769664809.png

Please look into the issue.

Status: Delivered
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎12-07-2023 01:41 AM

Hi  @shashankdeep ,

 

The “Memory error: Memory Allocation failure” message in Power BI Desktop typically indicates that the application has run out of memory while trying to complete a task.

If possible, you may add more RAM to your computer or upgrade to a system with higher memory capacity.
For now ,please try free up memory by closing unnecessary applications and processes that are running in the background. Simplify your data model by removing unnecessary columns or tables, splitting large tables, or using filters to limit the data loaded into memory.
If you’re using a 32-bit version, consider switching to the 64-bit version, which can access more memory and may help prevent memory errors.

Best regards.
Community Support Team_Caitlyn

 

Anonymous
Not applicable
‎01-02-2024 09:52 PM

Kindly see the comments below.

 

Best regards.
Community Support Team_Caitlyn

Idea Statuses