Excel Import error message when loading into Power BI desktop "migration failed"

[johnnypatino]

Hello Support,

I get an error message when trying to upload my excel data model into Power BI Desktop.

Error Message:

"Import Excel Workbook contents > migration failed.

Object reference not set to an instance of an object"

Error Message:

"Object reference not set to an instance of an object."

How do I go about finding and resolving the issue? Please help

Feedback Type:
Frown (Error)

Timestamp:
2021-02-09T02:20:36.5944783Z

Local Time:
2021-02-08T21:20:36.5944783-05:00

Session ID:
35be9392-5efe-41f4-9c51-875974058cc6

Release:
December 2020

Product Version:
2.88.1385.0 (20.12) (x64)

Stack Trace:
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.<>c__DisplayClass17_0.<SyncQueryAndTableNames>b__0(ITable t)
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.SyncQueryAndTableNames(Report newReport)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.UpdateConnectionStrings(IAnalysisServicesService analysisServices, String globalPipeName, ImportFromExcelSummary resultSummary, String newDatabaseName, List`1 listNonMQueries, CancellationToken cancellationToken, IProgress`1 progressHandler, List`1 deletedQueries, Report newReport)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.TryCreateReport(CancellationToken cancellationToken, IProgress`1 progressHandler, Stream fileStream, Dictionary`2 linkedTableMapping, IImportFromExcelHost host, Dictionary`2 sharedStrings, Report& newReport, ImportFromExcelError& error, ImportFromExcelSummary& resultSummary, PackageValidationResult& validationResult, Boolean& tryImportEmbedded)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.<>c__DisplayClass6_0.<CreateReportAsync>b__0()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- 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.FloatingDialog.ImportFromExcelDialog.<<StartImport>b__24_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.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.88.1385.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter+<>c__DisplayClass17_0","Error":"System.NullReferenceException","MethodDef":"<SyncQueryAndTableNames>b__0","ErrorOffset":"0"}

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

CLR Version:
4.7 or later [Release Number = 528372]

Peak Virtual Memory:
38.1 GB

Private Memory:
546 MB

Peak Working Set:
735 MB

IE Version:
11.630.19041.0

User ID:
86697747-11ab-4c40-90ee-9172b69b5834

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Is Report V3 Models Enabled:
True

Enabled Preview Features:
PBI_NewWebTableInference
PBI_v3ModelsPreview

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_JsonTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_eimInformationProtectionForDesktop
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList
PBI_cartesianMultiplesAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[v-alq-msft]

Hi, @johnnypatino 

I wonder if you have moved the file to other path. Please check if the path in Power Query is correct. Generally, you need to find the first step with error message for the query and troubleshot according to it.

Best Regards

Allan