Unable to convert to Import

[tamatha70]

The message said to post this here?

Feedback Type:
Frown (Error)

Timestamp:
2024-10-02T13:03:08.7619137Z

Local Time:
2024-10-02T08:03:08.7619137-05:00

Session ID:
fd51704e-d642-46f3-9a6f-0da7b499fee0

Release:
September 2024

Product Version:
2.136.1202.0 (24.09) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.JavaScriptException
at ViewModel.prototype.onActionButtonClick (ms-pbi://pbi.microsoft.com/ts/Controls/InfoBarControl.js:199:13)
at click (Function code:1:86)
at click (ms-pbi://pbi.microsoft.com/ts/Shared/Button.js:190:46)
at Anonymous function (ms-pbi://pbi.microsoft.com/ts/Shared/Button.js:27:21)
at n.event.dispatch (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:7481)
at r.handle (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:5547)

Microsoft.PowerBI.Modeling.Contracts.ModelingEngineException
at Microsoft.PowerBI.Modeling.Engine.SchemaChangeRoutingVisitor.ThrowIfQueryUsageNotAllowed(ObjectType objectType, Boolean isQueryModifiedByChange)
at Microsoft.PowerBI.Modeling.Engine.SchemaChangeRoutingVisitor.Visit(TableCacheModeSchemaChange schemaChange)
at System.Collections.Generic.List`1.ForEach(Action`1 action)
at Microsoft.PowerBI.Modeling.Engine.SchemaChangeRoutingVisitor.Route(ModelChange modelChange)
at Microsoft.PowerBI.Modeling.Engine.ModelingEngine.<RouteModelChangeAsync>d__15.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.Modeling.Hosting.DesktopModelingHost.<>c__DisplayClass39_0.<<RouteToLocalModel>b__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.Report.<>c__DisplayClass76_0.<<SynchronizeLooselyWithQueriesAsync>b__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.Report.<SynchronizeLooselyWithQueriesAsync>d__75`1.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.Modeling.Hosting.DesktopModelingHost.<RouteToLocalModel>d__39.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.Modeling.ModelAuthoringRoutingService.<>c__DisplayClass19_0.<<RouteToLocalModel>b__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.Modeling.ModelAuthoringRoutingService.<RouteToLocalModel>d__19.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion[T](Task`1 task)
at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringRoutingService.Route(Report report, ModelChange change, String rootActivityId)
at Microsoft.PowerBI.Client.Windows.Modeling.StorageModeHelpers.ConvertAllTablesToImport(IReportManager reportManager, IModelAuthoringRoutingService modelAuthoringRoutingService, IPowerBIWindowService windowService, IPowerBITelemetryService telemetryService, LocalizedString existingMode)
at Microsoft.PowerBI.Client.Windows.HtmlControls.QueriesView.QueryResultHtmlControl.OnDirectQueryInfoBarButtonClicked()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.136.1202.0","ModuleName":"Microsoft.PowerBI.Modeling.Engine.dll","Component":"Microsoft.PowerBI.Modeling.Engine.SchemaChangeRoutingVisitor","Error":"Microsoft.PowerBI.Modeling.Contracts.ModelingEngineException","MethodDef":"ThrowIfQueryUsageNotAllowed","ErrorOffset":"111","ErrorCode":""}

InnerException0.Stack Trace:
at Microsoft.PowerBI.Modeling.Engine.SchemaChangeRoutingVisitor.ThrowIfQueryUsageNotAllowed(ObjectType objectType, Boolean isQueryModifiedByChange)
at Microsoft.PowerBI.Modeling.Engine.SchemaChangeRoutingVisitor.Visit(TableCacheModeSchemaChange schemaChange)
at System.Collections.Generic.List`1.ForEach(Action`1 action)
at Microsoft.PowerBI.Modeling.Engine.SchemaChangeRoutingVisitor.Route(ModelChange modelChange)
at Microsoft.PowerBI.Modeling.Engine.ModelingEngine.<RouteModelChangeAsync>d__15.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.Modeling.Hosting.DesktopModelingHost.<>c__DisplayClass39_0.<<RouteToLocalModel>b__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.Report.<>c__DisplayClass76_0.<<SynchronizeLooselyWithQueriesAsync>b__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.Report.<SynchronizeLooselyWithQueriesAsync>d__75`1.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.Modeling.Hosting.DesktopModelingHost.<RouteToLocalModel>d__39.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.Modeling.ModelAuthoringRoutingService.<>c__DisplayClass19_0.<<RouteToLocalModel>b__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.Modeling.ModelAuthoringRoutingService.<RouteToLocalModel>d__19.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion[T](Task`1 task)
at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringRoutingService.Route(Report report, ModelChange change, String rootActivityId)
at Microsoft.PowerBI.Client.Windows.Modeling.StorageModeHelpers.ConvertAllTablesToImport(IReportManager reportManager, IModelAuthoringRoutingService modelAuthoringRoutingService, IPowerBIWindowService windowService, IPowerBITelemetryService telemetryService, LocalizedString existingMode)
at Microsoft.PowerBI.Client.Windows.HtmlControls.QueriesView.QueryResultHtmlControl.OnDirectQueryInfoBarButtonClicked()

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

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

Peak Virtual Memory:
72.8 GB

Private Memory:
1.75 GB

Peak Working Set:
1.91 GB

IE Version:
11.1.22621.0

User ID:
6ac632f5-a2c2-4d8b-b149-f05abeb59ce1

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

Telemetry Enabled:
True

Model Default Mode:
Composite

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_EimLessElevatedUser
PBI_mobileAutoReportLayout
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_generateMeasureDescriptionsButton
PBI_visualCalculationsAuthoring
PBI_desktopReportAuthoringCopilot

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_odspSaveBackgroundUpload
PBI_publishDialogsSupportSubfolders
PBI_tmdlInDataset
PBI_enhancedReportFormat
PBI_directLakeRemoteModeling
PBI_qnaImproveLsdlCopilot

Enabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

[v-xiaoyan-msft]

Hi @tamatha70 ,

Please make sure your Power BI Desktop is downloaded from Download Microsoft Power BI Desktop from Official Microsoft Download Center instead of MS app store.

You may re-install it and try it again.

Best regards.
Community Support Team_Caitlyn

[tamatha70]

Thank you, I did this and while it didn't help my issue, I was able to resolve the issue by going into each individual source, making sure the related columns were unchecked and import was selected.

[v-xiaoyan-msft]

Hi @tamatha70 ,

Thank you for sharing, for other users with similar experiences you can check the comments below. This thread will now be closed.

Best regards.
Community Support Team_ Caitlyn