Data Load Error

[Shivam97]

Feedback Type:
Frown (Error)

Timestamp:
2022-06-15T06:26:36.1531883Z

Local Time:
2022-06-15T11:56:36.1531883+05:30

Session ID:
bbcb7707-e560-4d13-aa50-1d158dc7dd4c

Release:
May 2022

Product Version:
2.105.1143.0 (22.05) (x86)

Stack Trace:
System.InvalidOperationException
at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, IFileManager fileManager, IFileHistoryManager fileHistoryManager, String filePath, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_1.<Main>b__2()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.105.1143.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"System.InvalidOperationException","MethodDef":"HandleError - 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_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_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_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_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_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_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_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_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_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_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_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_XM_COLUMN_LOAD_ERROR,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_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_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_BAD_ALLOC,PFE_XM_COLUMN_LOAD_ERROR,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA","ErrorOffset":"0"}

InnerException0.Stack Trace:
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.ExecuteXmla(String xmla)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.<>c__DisplayClass50_0.<ImageLoadDatabaseFromPbix>b__0()
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.OnErrorClarify(Action action, String clarification)

InnerException1.Stack Trace:

OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)

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

Peak Virtual Memory:
1.13 GB

Private Memory:
251 MB

Peak Working Set:
381 MB

IE Version:
11.1411.18362.0

User ID:
6b09e182-8b63-4a57-9ec3-6043ddee726e

Telemetry Enabled:
True

DPI Scale:
150%

Supported Services:
Power BI

The above error is what I'm facing while loading my data from Snowflake to my Power BI datamartI would be glad if anyone could help out

[v-cazheng-msft]

Hi @Shivam97,

You may try the solution from v-shex-msft in the similar issue: Solved: "We weren't able to restore the saved database to ... - Microsoft Power BI Community.

If it doesn’t work, you may consider the older version Power BI Desktop. If you don't have problems with an older one, then please take it as a workaround curretnly. Here is the link of older versions: Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Docs

Best Regards,

Community Support Team _ Caiyun