Import Excel Workbook Contents - Migration Failed

[fixmyissue]

Feedback Type:
Frown (Error)

Timestamp:
2023-01-25T01:52:22.5320127Z

Local Time:
2023-01-25T12:52:22.5320127+11:00

Session ID:
7d298cda-ebc0-44d9-8766-77588a78eb8b

Release:
November 2022

Product Version:
2.111.590.0 (22.11) (x64)

Stack Trace:
System.NotSupportedException
at Microsoft.PowerBI.Client.Windows.Modeling.Extended.DataModel.ValidateName(ObjectType objectType, String tablename, String oldName, String name, Boolean validateOnlyNonQueryItems)
at Microsoft.PowerBI.Client.Windows.PowerBIFormulaNameGenerator.ValidateIsNameAllowed(IAnalysisServicesDatabaseProvider analysisServicesDatabaseProvider, String currentQueryName, String desiredName)
at Microsoft.PowerBI.Client.Windows.PowerBIFormulaNameGenerator.IsNameAllowed(String desiredName, IEnumerable`1 disallowedNames)
at Microsoft.Mashup.DocumentServices.Names.NameGenerator.GenerateDisambiguatedName(String desiredName, Predicate`1 isNameAllowed)
at Microsoft.Mashup.Host.Document.PackageSection.AddFormula(String desiredFormulaName, String prohibitedFormulaName, Boolean isBaseName, String formulaText, Boolean allowDiscouragedNames)
at Microsoft.Mashup.Host.Document.PackageEditor.TryAddFormula(String sectionName, String formulaName, Boolean isBaseName, String formulaText, Boolean allowDiscouragedNames, String& actualFormulaName)
at Microsoft.Mashup.Host.Document.FormulaEditor.AddFormula(PackageEditor packageEditor, String sectionName, String formulaName, String formulaText, Boolean isBaseName, MultiLocalizedString firstFormulaPartName, Boolean allowDiscouragedNames, String& actualFormulaName)
at Microsoft.Mashup.Host.Document.Model.Queries.AddQuery(String name, Boolean isBaseName, String formulaText)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.<ConvertNonMQueries>d__22.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.Storage.ExcelImporter.<TryCreateReport>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Modeling.Common.TaskExtensions.WaitAndUnpackException[T](Task`1 task)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.<>c__DisplayClass7_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.111.590.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Modeling.Extended.DataModel","Error":"System.NotSupportedException","MethodDef":"ValidateName","ErrorOffset":"10"}

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

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

Peak Virtual Memory:
70.7 GB

Private Memory:
768 MB

Peak Working Set:
1.05 GB

IE Version:
11.789.19041.0

User ID:
2a708a01-69bc-4161-b1a3-1dba87f6b711

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

Telemetry Enabled:
True

AS Live Connection:
True

Enabled Preview Features:
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_enableWebView2
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_optimizeTabRibbon
PBI_relationshipEditPane

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PQ_WebView2Connector
PBI_horizontalFusion

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[Anonymous]

Hi @fixmyissue 

What operation are you doing with this error? Was it working properly before?

Best Regards,
Community Support Team _ Ailsa Tao

[fixmyissue]

Hello Ailsa, I am importing an Excel Workbook that contains a data model.

I select from PowerBI Import, (Power Query, Power Pivot, Power View.

The process runs and I receive a message saying there are some queries in the data model tables that depend on other worksheet tables, and do I wish to copy the data from those tables to PowerBI Desktop File or keep a connection to the origianl Excel workbook. 

No matter what option I select, either Copy Data or Keep Connection I receive the error .

Something went wrong.  Name validation is not supported for readonly schemas, Migration failed.

Not sure what this is.

I have used another method to extract the excel data model, via publishing directly from Excel, but I was wanting a solution that allowed more flexibility in transforming the data.  For example currently using the export feature in excel, when I connect PowerBI to the dataset I am unable to transform the data or use most of the modeling fuctions.

Thanks for your help.