Error al cargar datos

[NewuserOsw287]

Hi community, I tried to loaded my file xlsx, but, i get this message "No se puede encontrar el valor solicitado '()1'."

I sent you the error information:

Feedback Type:
Frown (Error)

Error Message:
No se puede encontrar el valor solicitado '()1'.

Stack Trace:
System.ArgumentException
en System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
en System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
en Microsoft.AnalysisServices.Tabular.RowsetPropertyReader.Microsoft.AnalysisServices.Tabular.IPropertyReader.TryReadProperty[T](String propName, T& propValue)
en Microsoft.AnalysisServices.Tabular.Partition.ReadAllBodyProperties(IPropertyReader reader, CompatibilityMode mode, Int32 dbCompatibilityLevel)
en Microsoft.AnalysisServices.Tabular.DdlUtil.LoadImpactRow(ObjectType objectType, CompatibilityMode mode, Int32 dbCompatibilityLevel, RowsetPropertyReader rowsetPropReader, ServerImpact serverImpact, StringComparerInfo comparerInfo)
en Microsoft.AnalysisServices.Tabular.DdlUtil.LoadImpactTable(ObjectType objectType, CompatibilityMode mode, Int32 dbCompatibilityLevel, DataTable tbl, ServerImpact impact, StringComparerInfo comparerInfo)
en Microsoft.AnalysisServices.Tabular.DdlUtil.LoadImpactFromSchema(DataSet schema, CompatibilityMode mode, Int32 dbCompatibilityLevel, ServerImpact serverImpact, StringComparerInfo comparerInfo)
en Microsoft.AnalysisServices.Tabular.ImpactDataSet.ConvertToServerImpact(CompatibilityMode mode, Int32 dbCompatibilityLevel, StringComparerInfo comparerInfo)
en Microsoft.AnalysisServices.Tabular.ExecuteUtil.ApplyImpactToModel(Model model, ImpactDataSet impactDataSet)
en Microsoft.AnalysisServices.Tabular.ExecuteUtil.TryExecuteXmla(Model model, String xmlaRequest, XmlaResultCollection& xmlaResults)
en Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl(SaveOptions options)
en Microsoft.PowerBI.Modeler.ModelManager.<SaveChanges>b__234_0()
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass6_0`1.<RunInActivity>b__0()
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity[T](ModelingActivityKind activity, Func`1 action)
en Microsoft.PowerBI.Modeler.ModelManager.SaveChanges(String description)
en Microsoft.PowerBI.Modeler.DateTableSubsystem.CreateDateTableTemplate(DateTableDefinition definition)
en Microsoft.PowerBI.Modeler.DateTableSubsystem.SynchronizeLocalDateTables(String description)
en Microsoft.PowerBI.Modeler.DateTableSubsystem.EnableAutomaticLocalDateTables()
en Microsoft.PowerBI.Modeler.DateTableSubsystem.EnableTimeIntelligenceIfNewModel()
en Microsoft.PowerBI.Modeler.DateTableSubsystem.SynchronizeLocalDateTables(String description)
en Microsoft.PowerBI.Modeler.ModelManager.OnTableCacheModeSet(ModeType newModeType, String description)
en Microsoft.PowerBI.Modeler.ModelManager.PopulateTableItems(Table table, ModeType modeType, IReadOnlyList`1 columns, IReadOnlyList`1 measures)
en Microsoft.PowerBI.Modeler.ModelManager.CreateTable(String tableName, ModeType dataMode, String mashupExpression, IReadOnlyList`1 columns)
en Microsoft.PowerBI.Modeling.Engine.Authoring.SchemaChangeApplier.Visit(NewTableSchemaChange schemaChange)
en Microsoft.PowerBI.Modeling.Engine.Authoring.SchemaChangeApplier.Apply(IModelManager modelManager, IEnumerable`1 changes, IRefreshPolicyUpdater refreshPolicyUpdater)
en Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.ExecuteChange(ModelChange modelChange, Boolean saveChange, ISchemaChangeApplierFactory schemaChangeApplierFactory, IRefreshPolicyUpdater refreshPolicyUpdater, IPrivateInformationService piiService, String descriptionToTrace)
en Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ExtendedModelChangeScopeBase.ExecuteChange(ModelChange modelChange, Boolean saveChange, RecalcBehavior recalcBehavior, String descriptionToTrace)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelSchemaSynchronizer.ApplyQuerySchemaToModel(IModelInput modelInput, IExtendedModelChangeScope modelChangeScope, Boolean requireFullDataRefresh)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.ApplyQueriesToModel(ILoadResultEvaluationProgressProvider evaluationProgressProvider, IExtendedModelChangeScope modelChangeScope, Action`1 beforeSchemaSyncCallback, Action`1 afterSchemaSyncCallback, Boolean& runRelationshipDetection, List`1& newTableColumnPairs, HashSet`1& existingTableInputs)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.ProcessLoadInputs(IRelationshipLoader relationshipLoader, IExtendedModelChangeScope modelChangeScope, Action`1 beforeSchemaSyncCallback, Action`1 afterSchemaSyncCallback)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<>c__DisplayClass20_0.<PerformLoadInternal>b__0(IExtendedModelChangeScope modelChangeScope)
en Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass14_0.<RunExtendedModelChangeAsync>b__0()
en System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
en System.Threading.Tasks.Task.Execute()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en Microsoft.PowerBI.Modeling.Common.TaskExtensions.WaitAndUnpackException(Task task)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.PerformLoadInternal(IRelationshipLoader relationshipLoader, IModelAuthoringChangeScopeProvider authoringChangeScopeProvider, IModelingQueryServices queryServices, Action`1 beforeSchemaSyncCallback, Action`1 afterSchemaSyncCallback, IRefreshPolicyUpdater refreshPolicyUpdater, Boolean skipImpactAnalysisWarning)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<>c__DisplayClass19_0.<PerformLoadAsync>b__3()
en System.Threading.Tasks.Task`1.InnerInvoke()
en System.Threading.Tasks.Task.Execute()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass8_0`1.<<RunInAsyncActivity>b__0>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__7.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__8`1.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<PerformLoadToAnalysisServices>d__34.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<ExecuteInternal>d__29.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<Execute>d__28.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.ModelingEngine.<LoadModelAsyncInternal>d__11.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass8_0`1.<<RunInAsyncActivity>b__0>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__7.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__8`1.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingService.<LoadToModel>d__16.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass34_0.<<StartLoadToReportFlow>b__0>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

Stack Trace Message:
No se puede encontrar el valor solicitado '()1'.

Invocation Stack Trace:
en Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
en Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
en Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
en Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
en Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
en Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
en Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
en System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
en System.Threading.Tasks.Task.FinishContinuations()
en System.Threading.Tasks.Task.Finish(Boolean bUserDelegateExecuted)
en System.Threading.Tasks.Task`1.TrySetException(Object exceptionObject)
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetException(Exception exception)
en Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass34_0.<<StartLoadToReportFlow>b__0>d.MoveNext()
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
en System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
en System.Threading.Tasks.Task.FinishContinuations()
en System.Threading.Tasks.Task.Finish(Boolean bUserDelegateExecuted)
en System.Threading.Tasks.Task`1.TrySetException(Object exceptionObject)
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetException(Exception exception)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingService.<LoadToModel>d__16.MoveNext()
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
en System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
en System.Threading.Tasks.Task.FinishContinuations()
en System.Threading.Tasks.Task.Finish(Boolean bUserDelegateExecuted)
en System.Threading.Tasks.Task`1.TrySetException(Object exceptionObject)
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetException(Exception exception)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__8`1.MoveNext()
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
en System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
en System.Threading.Tasks.Task.FinishContinuations()
en System.Threading.Tasks.Task.Finish(Boolean bUserDelegateExecuted)
en System.Threading.Tasks.Task`1.TrySetException(Object exceptionObject)
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetException(Exception exception)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__7.MoveNext()
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
en System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
en System.Threading.Tasks.Task.FinishContinuations()
en System.Threading.Tasks.Task.Finish(Boolean bUserDelegateExecuted)
en System.Threading.Tasks.Task`1.TrySetException(Object exceptionObject)
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetException(Exception exception)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass8_0`1.<<RunInAsyncActivity>b__0>d.MoveNext()
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
en System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
en System.Threading.Tasks.Task.FinishContinuations()
en System.Threading.Tasks.Task.Finish(Boolean bUserDelegateExecuted)
en System.Threading.Tasks.Task`1.TrySetException(Object exceptionObject)
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetException(Exception exception)
en Microsoft.PowerBI.Modeling.Engine.ModelingEngine.<LoadModelAsyncInternal>d__11.MoveNext()
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
en System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
en System.Threading.Tasks.Task.FinishContinuations()
en System.Threading.Tasks.Task.Finish(Boolean bUserDelegateExecuted)
en System.Threading.Tasks.Task`1.TrySetException(Object exceptionObject)
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetException(Exception exception)
en Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<Execute>d__28.MoveNext()

[v-chuncz-msft]

@NewuserOsw287 

You may check Minimum requirements and Troubleshoot opening Power BI Desktop.