Please help. Here is the error I get when trying to import datamodel into PB Desktop. I really dont want to recreate it all again...
"Migration Failed"
Object refrerence not set an instance of an object.
I've copied the Details below
Feedback Type:
Frown (Error)
Timestamp:
2021-02-17T19:15:18.3938833Z
Local Time:
2021-02-17T14:15:18.3938833-05:00
Session ID:
572a3690-250c-4165-91b0-76d1e46f0315
Release:
December 2020
Product Version:
2.88.1682.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.1682.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.18363.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 528040]
Peak Virtual Memory:
40 GB
Private Memory:
1.57 GB
Peak Working Set:
1.85 GB
IE Version:
11.1198.18362.0
User ID:
9340e73b-1768-4d73-a814-c1f915098678
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Enabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
AS Live Connection:
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
