Can't access a report after downloading it with data

[FMMagallanes]

Hi everyone,

I'm having problems with a report which I need to modify. I've downloaded the last version of it, but every time I try to open it I get an error on the lines of the following:

Feedback Type:
Frown (Error)

Error Message:
Error Code = 0xC1000012, External Code = 0x00000000, Note:
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.<CreateLocalDatabase>d__7.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__19.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__42.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__DisplayClass29_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:
Error Code = 0xC1000012, External Code = 0x00000000, Note:
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.124.1805.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Services.AnalysisServicesDatabaseFactory+<CreateLocalDatabase>d__7","Error":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenException","MethodDef":"MoveNext - PFE_ERROR_IN_ERROR_HANDLING,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA","ErrorOffset":"508","ErrorCode":"DataModelLoadFailed"}

InnerException0.Stack Trace Message:
Error Code = 0xC1000012, External Code = 0x00000000, Note:
An error occurred while loading Vertipaq data objects for multiple tables.

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.AnalysisServicesDatabaseFactory.<CreateLocalDatabase>d__7.MoveNext()

InnerException0.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.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
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_ErrorCode:
DataModelLoadFailed

PowerBINonFatalError_MethodDefDescription:
PFE_ERROR_IN_ERROR_HANDLING,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA

PowerBIUserFeedbackServices_IsReported:
True

InnerException0.PowerBINonFatalError_ErrorDescription:
PFE_ERROR_IN_ERROR_HANDLING,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA

InnerException0.PowerBINonFatalError_MethodDefDescription:
PFE_ERROR_IN_ERROR_HANDLING,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA

[Anonymous]

Hi @FMMagallanes ,

Based on the error code you‘ve provided,it usually occurs when there are old calculated columns that have been broken, even if they are not used anywhere else and are not used on the report.

Please check your report for any old calculated columns that may be broken.If you find any, remove them from your report.After removing these columns, re-publish your report to the service for a test.

Best regards.
Community Support Team_Caitlyn

[FMMagallanes]

Hi @Anonymous 

The problem is that the report wasn't created by me, and I can't open it in order to check and correct broken calculated columns 😞

I tried opening it again and I got a kind of different error:

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.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1189.Deal Team (289).T1 End Date c (1536).0.idf'. (Deal Team (289)).
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.
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 '1189.Deal Team (289).Start DateTime c (26105887).0.idf'. (Deal Team (289)).
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 '1189.Deal Team (289).ConnectionReceivedId (26105691).0.idf'. (Deal Team (289)).
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.
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 '1223.Deal (22).T1C Base Expected Close Date c (513).0.idf'. (Deal (22)).
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.
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1189.Deal Team (289).Reason Description c (26105867).0.idf'. (Deal Team (289)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1185.Interest Subject Coverage (187).LastModifiedById (1293).0.idf'. (Interest Subject Coverage (187)).
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 '1223.Deal (22).T1C Base Actual Close Date c (511).0.idf'. (Deal (22)).
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 '1189.Deal Team (289).MCO Team Member Id c (26105859).0.idf'. (Deal Team (289)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1736.Deal Product (55).T1 Closing Date c (729).0.idf'. (Deal Product (55)).
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 '1736.Interest Subject (160).T1C Base Parent Interest Subject c (1209).0.idf'. (Interest Subject (160)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1188.Account Coverage Additional Info (43).T1C Base End Date c (618).0.idf'. (Account Coverage Additional Info (43)).
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 '1188.Deal Contact (145).T1C Base Title c (1162).0.idf'. (Deal Contact (145)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1736.Deal Product (55).RowNumber 2662979B 1795 4F74 8F37 6A1BA8059B61 (56).0.idf'. (Deal Product (55)).
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Error happened while loading table '', file '1215.STG R SF DEAL SEC Unpivot (280).Deal Sec Email (1508).0.idf'. (STG R SF DEAL SEC Unpivot (280)).
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 '1189.Deal Team (289).Start Time c (26105979).0.idf'. (Deal Team (289)).
An error occurred while loading Vertipaq data objects for multiple tables.

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.AnalysisServicesDatabaseFactory.<CreateLocalDatabase>d__7.MoveNext()

InnerException0.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.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
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_ErrorCode:
DataModelLoadFailed

PowerBINonFatalError_MethodDefDescription:
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_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,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_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA

PowerBIUserFeedbackServices_IsReported:
True

InnerException0.PowerBINonFatalError_ErrorDescription:
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_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,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_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_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA

InnerException0.PowerBINonFatalError_MethodDefDescription:
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_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA

This same type of error happens in other attempts to open the file, with different tables/fields shown in the detail. Just to put it out there, I have tried downloading the file in different ocassions so I don't think it's due to a corrupt download.

[FMMagallanes]

So, as an update, the problem got fixed after installing the newest version of PowerBI.