Corrupted system DSN

%3CLINGO-SUB%20id%3D%22lingo-sub-1205271%22%20slang%3D%22en-US%22%3ECorrupted%20system%20DSN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1205271%22%20slang%3D%22en-US%22%3E%3CP%3EI%20somehow%20corrupted%20one%20of%20my%20system%20DSNs.%26nbsp%3B%20Now%20when%20I%20try%20to%20create%20or%20use%20a%20Power%20Query%20with%20that%20data%20source%2C%20I%20get%20an%20error%20(listed%20below)%20basically%20telling%20me%20that%20my%20username%20or%20password%20are%20incorrect.%26nbsp%3B%20Yet%20when%20I%20test%20the%20connection%20through%20ODBC%20Data%20Source%20Administration%20(32-bit)%20it%20works%20just%20fine.%26nbsp%3B%20I%20am%20not%20being%20prompted%20for%20the%20User%20name%20and%20password%20when%20I%20try%20to%20connect%20through%20Power%20Query%2C%20so%20how%20are%20the%20credentials%20wrong%3F%26nbsp%3B%20Until%20today%20I%20had%20no%20problem%20using%20this%20specific%20data%20source%20through%20Power%20Query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20rebooting%20many%20times%2C%20deleting%20and%20recreating%20the%20data%20source%2C%20created%20a%20new%20identical%20data%20source%20with%20a%20different%20name%20(which%20worked%20perfectly)%2C%20doing%20a%20system%20restore%20(which%20was%20not%20successful%20so%20nothing%20was%20changed).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20what%20can%20I%20try%20next%3F%26nbsp%3B%20There%20must%20be%20some%20sort%20of%20Excel%20Power%20Query%20specific%20system%20file%20which%20is%20corrupted.%26nbsp%3B%20I%20have%20other%20types%20of%20ODBC%20queries%20which%20also%20use%20this%20data%20source%20and%20they%20work%20just%20fine%2C%20but%20they%20also%20save%20the%20user%20name%20and%20password%20in%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%2264%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3EFeedback%20Type%3A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFrown%20(Error)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EError%20Message%3A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EThe%20user%20name%20or%20password%20is%20incorrect.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EStack%20Trace%3A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMicrosoft.Mashup.Evaluator.Interface.ErrorException%3A%20The%20user%20name%20or%20password%20is%20incorrect.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E---%26gt%3B%20System.Security.SecurityException%3A%20The%20user%20name%20or%20password%20is%20incorrect.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E---%26gt%3B%20System.Security.SecurityException%3A%20The%20user%20name%20or%20password%20is%20incorrect.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Security.Principal.WindowsIdentity.KerbS4ULogon(String%20upn%2C%20SafeAccessTokenHandle%26amp%3B%20safeTokenHandle)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Security.Principal.WindowsIdentity..ctor(String%20sUserPrincipalName%2C%20String%20type)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Security.Principal.WindowsIdentity..ctor(String%20sUserPrincipalName)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.CredentialExtensions.GetImpersonationWrapper(String%20username%2C%20String%20password%2C%20IEngineHost%20host%2C%20IResource%20resource)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.CredentialExtensions.GetImpersonationWrapper(IResourceCredential%20credential%2C%20IEngineHost%20host%2C%20IResource%20resource)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Common.GenericConnectionStringBuilder.GetImpersonationWrapper(WindowsCredential%20credential)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Common.SqlResourceCredentialDispatcher.Apply(WindowsCredential%20credential)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Common.ResourceCredentialDispatcher.Apply(IResourceCredential%20credential)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Common.GenericConnectionStringBuilder.Apply(ResourceCredentialCollection%20credentials)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Common.ConnectionStringResourceCredentialDispatcher.ConstructConnectionString(String%20server%2C%20String%20database%2C%20ResourceCredentialCollection%20credentials%2C%20Nullable%601%20connectionTimeout)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.Initialize()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.GetCacheKey(String%20commandText%2C%20IList%601%20parameters%2C%20RowRange%20range)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExecuteWithoutPaging(String%20commandText%2C%20IList%601%20parameters%2C%20RowRange%20range%2C%20String%5B%5D%20columnNames%2C%20ColumnConversion%5B%5D%20columnConversions)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Odbc.OdbcNativeQueryTableValue.GetReaderCore()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Odbc.OdbcNativeQueryTableValue.get_Type()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.TableValue.Take(RowCount%20count)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.WrappingTableValue.Take(RowCount%20count)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.DelegatingTableValue.Take(RowCount%20count)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.TableValue.Take(Value%20countOrCondition)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Library.Table.TableModule.Table.FirstNFunctionValue.TypedInvoke(TableValue%20table%2C%20Value%20countOrCondition)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2%603.Invoke(Value%20arg0%2C%20Value%20arg1)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.FunctionValue.MetaTypeFunctionValue.Invoke(Value%20arg0%2C%20Value%20arg1)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.SerializationApplyingModule.SerializableFunctionValue.Invoke(Value%20arg0%2C%20Value%20arg1)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1%26amp%3B%20frame)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1%26amp%3B%20frame)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1%26amp%3B%20frame)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1%26amp%3B%20frame)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(MembersFrame1%26amp%3B%20frame)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1%26amp%3B%20frame)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value%20arg0)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32%20index)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32%20index)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String%20field)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame0%26amp%3B%20frame)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value%5B%5D%20args)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Invoke(IValue%20function%2C%20IValue%5B%5D%20arguments)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters%20parameters%2C%20Action%601%20callback)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters%20parameters%2C%20Action%601%20callback)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult%5BT%5D(Action%601%20callback)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation%601.OnBufferComplete(Exception%20exception)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Firewall.BufferNextPartition(List%601%20partitionsToBuffer%2C%20Int32%20nextPartition%2C%20Action%601%20callback)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action%601%20callback)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal%5BT%5D(DocumentEvaluationParameters%20parameters%2C%20Action%601%20callback)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters%20parameters%2C%20Action%601%20callback)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult%5BT%5D(IDocumentEvaluator%601%20evaluator%2C%20DocumentEvaluationParameters%20parameters)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult%5BT%5D(IMessageChannel%20channel%2C%20BeginGetResultMessage%20message%2C%20Action%601%20action)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel%20channel%2C%20BeginGetPreviewValueSourceMessage%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.%26lt%3B%26gt%3Bc__DisplayClassa%601.%3CADDHANDLER%3Eb__8(IMessageChannel%20channel%2C%20Message%20message)%3C%2FADDHANDLER%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel%20baseChannel%2C%20MessageWithUnknownChannel%20messageWithUnknownChannel)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.%26lt%3B%26gt%3Bc__DisplayClassa%601.%3CADDHANDLER%3Eb__8(IMessageChannel%20channel%2C%20Message%20message)%3C%2FADDHANDLER%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.EvaluationHost.Run()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object%20args)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.SafeThread2.%26lt%3B%26gt%3Bc__DisplayClass2.%3CCREATETHREADSTART%3Eb__0(Object%20o)%3C%2FCREATETHREADSTART%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.SafeThread2.%26lt%3B%26gt%3Bc__DisplayClass15.%3CCREATEACTION%3Eb__14(Object%20o)%3C%2FCREATEACTION%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20---%20End%20of%20inner%20exception%20stack%20trace%20---%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.EvaluationHost.%26lt%3B%26gt%3Bc__DisplayClass7.%3CTRYREPORTEXCEPTION%3Eb__6()%3C%2FTRYREPORTEXCEPTION%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost%20host%2C%20IHostTrace%20trace%2C%20Action%20action)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace%20trace%2C%20IEngineHost%20engineHost%2C%20IMessageChannel%20channel%2C%20Exception%20exception)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.EvaluationHost.TryHandleException(Exception%20exception)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.SafeThread2.HandleException(Exception%20e)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.SafeThread2.%26lt%3B%26gt%3Bc__DisplayClass15.%3CCREATEACTION%3Eb__14(Object%20o)%3C%2FCREATEACTION%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.SafeThread2.%26lt%3B%26gt%3Bc__DisplayClass2.%3CCREATETHREADSTART%3Eb__1(Object%20o)%3C%2FCREATETHREADSTART%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String%5B%5D%20args)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Container.EvaluationContainerMain.Main(String%5B%5D%20args)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20---%20End%20of%20inner%20exception%20stack%20trace%20---%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost%20engineHost%2C%20IMessageChannel%20channel%2C%20ExceptionMessage%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.Container.OnException(IMessageChannel%20channel%2C%20ExceptionMessage%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.%26lt%3B%26gt%3Bc__DisplayClassa%601.%3CADDHANDLER%3Eb__8(IMessageChannel%20channel%2C%20Message%20message)%3C%2FADDHANDLER%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel%20baseChannel%2C%20MessageWithUnknownChannel%20messageWithUnknownChannel)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.%26lt%3B%26gt%3Bc__DisplayClassa%601.%3CADDHANDLER%3Eb__8(IMessageChannel%20channel%2C%20Message%20message)%3C%2FADDHANDLER%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel%20channel%2C%20Message%20message)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor%5BT%5D(IMessageChannel%20channel)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func%601%20condition%2C%20Boolean%20disposing)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2%601%20result%2C%20Func%601%20getStaleSince%2C%20Func%601%20getSampled)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EInvocation%20Stack%20Trace%3A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String%20exceptionStackTrace%2C%20String%20invocationStackTrace%2C%20String%20exceptionMessage)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult%20exceptionView%2C%20Query%20query%2C%20String%20sourceID%2C%20String%20formulaTitle%2C%20Boolean%20isNewQuery%2C%20Boolean%20isFromEditor)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult%20preview%2C%20Query%20query%2C%20String%20sourceID%2C%20String%20formulaTitle%2C%20Nullable%601%20explicitImportDestination%2C%20Boolean%20isNewQuery%2C%20Boolean%20isFromEditor)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query%20query%2C%20String%20sourceID%2C%20String%20formulaTitle%2C%20Boolean%20isNewQuery%2C%20Boolean%20isFromEditor%2C%20Nullable%601%20explicitImportDestination)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass20.%3CGETPREVIEWRESULT%3Eb__1f()%3C%2FGETPREVIEWRESULT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook%20workbook%2C%20Action%20action)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook%20workbook%2C%20UndoableActionType%20actionType%2C%20Action%20action)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClass20.%3CGETPREVIEWRESULT%3Eb__1e(IWorkbook%20workbook)%3C%2FGETPREVIEWRESULT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClassa.%26lt%3B%26gt%3Bc__DisplayClassc.%3CNOTIFYGETDATAPRESENCE%3Eb__9()%3C%2FNOTIFYGETDATAPRESENCE%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook%20workbook%2C%20Action%20action)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClassa.%3CNOTIFYGETDATAPRESENCE%3Eb__8(IWorkbook%20workbook)%3C%2FNOTIFYGETDATAPRESENCE%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.%26lt%3B%26gt%3Bc__DisplayClassf.%3CINVOKEONWORKBOOK%3Eb__e(IWorkbook%20workbook%2C%20IWindowContext%20windowContext)%3C%2FINVOKEONWORKBOOK%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook%5BT%5D(Func%603%20action%2C%20T%20defaultValue)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook(Action%601%20action)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.NotifyGetDataPresence(Action%601%20action)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelDataImporter.GetPreviewResult(Query%20query%2C%20String%20sourceID%2C%20String%20formulaTitle%2C%20Boolean%20isNewQuery%2C%20Boolean%20isFromEditor%2C%20Nullable%601%20explicitImportDestination)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Client.UI.Shared.DataImporter.%26lt%3B%26gt%3Bc__DisplayClass20.%3CONQUERYSETTINGSRESOLVED%3Eb__1d()%3C%2FONQUERYSETTINGSRESOLVED%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler%20exceptionHandler%2C%20Action%20action)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.%26lt%3B%26gt%3Bc__DisplayClassf.%3CPOST%3Eb__e(Object%20null)%3C%2FPOST%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.RuntimeMethodHandle.InvokeMethod(Object%20target%2C%20Object%5B%5D%20arguments%2C%20Signature%20sig%2C%20Boolean%20constructor)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object%20obj%2C%20Object%5B%5D%20parameters%2C%20Object%5B%5D%20arguments)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Delegate.DynamicInvokeImpl(Object%5B%5D%20args)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry%20tme)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object%20obj)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Threading.ExecutionContext.RunInternal(ExecutionContext%20executionContext%2C%20ContextCallback%20callback%2C%20Object%20state%2C%20Boolean%20preserveSyncCtx)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Threading.ExecutionContext.Run(ExecutionContext%20executionContext%2C%20ContextCallback%20callback%2C%20Object%20state%2C%20Boolean%20preserveSyncCtx)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Threading.ExecutionContext.Run(ExecutionContext%20executionContext%2C%20ContextCallback%20callback%2C%20Object%20state)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry%20tme)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Windows.Forms.Control.InvokeMarshaledCallbacks()%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Windows.Forms.Control.WndProc(Message%26amp%3B%20m)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message%26amp%3B%20m)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message%26amp%3B%20m)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20at%20System.Windows.Forms.NativeWindow.Callback(IntPtr%20hWnd%2C%20Int32%20msg%2C%20IntPtr%20wparam%2C%20IntPtr%20lparam)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESupports%20Premium%20Content%3A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETRUE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFormulas%3A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Esection%20Section1%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Eshared%20Query1%20%3D%20let%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20Source%20%3D%20Odbc.Query(%22dsn%3Dglobal_fah%22%2C%20%22select%20top%2010%20*%20from%20inventory_mast%22)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Ein%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%20%26nbsp%3B%20Source%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1205271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1206869%22%20slang%3D%22en-US%22%3ERe%3A%20Corrupted%20system%20DSN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1206869%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20solved%20the%20problem.%26nbsp%3B%20From%20Edit%20Power%20%3D%26gt%3B%20Data%20Source%20Settings%20%3D%26gt%3B%20Global%20Permissions%3C%2FP%3E%3CP%3Ethen%20find%20the%20data%20source%20with%20the%20problem%2C%20right-click%20then%20select%20Clear%20Permissions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572666%22%20target%3D%22_blank%22%3E%40MkeMyers4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I somehow corrupted one of my system DSNs.  Now when I try to create or use a Power Query with that data source, I get an error (listed below) basically telling me that my username or password are incorrect.  Yet when I test the connection through ODBC Data Source Administration (32-bit) it works just fine.  I am not being prompted for the User name and password when I try to connect through Power Query, so how are the credentials wrong?  Until today I had no problem using this specific data source through Power Query.

 

I have tried rebooting many times, deleting and recreating the data source, created a new identical data source with a different name (which worked perfectly), doing a system restore (which was not successful so nothing was changed).

 

So what can I try next?  There must be some sort of Excel Power Query specific system file which is corrupted.  I have other types of ODBC queries which also use this data source and they work just fine, but they also save the user name and password in them.

 

 

Feedback Type:
Frown (Error)
 
Error Message:
The user name or password is incorrect.
 
 
Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: The user name or password is incorrect.
---> System.Security.SecurityException: The user name or password is incorrect.
---> System.Security.SecurityException: The user name or password is incorrect.
 
    at System.Security.Principal.WindowsIdentity.KerbS4ULogon(String upn, SafeAccessTokenHandle& safeTokenHandle)
    at System.Security.Principal.WindowsIdentity..ctor(String sUserPrincipalName, String type)
    at System.Security.Principal.WindowsIdentity..ctor(String sUserPrincipalName)
    at Microsoft.Mashup.Engine1.Runtime.CredentialExtensions.GetImpersonationWrapper(String username, String password, IEngineHost host, IResource resource)
    at Microsoft.Mashup.Engine1.Runtime.CredentialExtensions.GetImpersonationWrapper(IResourceCredential credential, IEngineHost host, IResource resource)
    at Microsoft.Mashup.Engine1.Library.Common.GenericConnectionStringBuilder.GetImpersonationWrapper(WindowsCredential credential)
    at Microsoft.Mashup.Engine1.Library.Common.SqlResourceCredentialDispatcher.Apply(WindowsCredential credential)
    at Microsoft.Mashup.Engine1.Library.Common.ResourceCredentialDispatcher.Apply(IResourceCredential credential)
    at Microsoft.Mashup.Engine1.Library.Common.GenericConnectionStringBuilder.Apply(ResourceCredentialCollection credentials)
    at Microsoft.Mashup.Engine1.Library.Common.ConnectionStringResourceCredentialDispatcher.ConstructConnectionString(String server, String database, ResourceCredentialCollection credentials, Nullable`1 connectionTimeout)
    at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.Initialize()
    at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.GetCacheKey(String commandText, IList`1 parameters, RowRange range)
    at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExecuteWithoutPaging(String commandText, IList`1 parameters, RowRange range, String[] columnNames, ColumnConversion[] columnConversions)
    at Microsoft.Mashup.Engine1.Library.Odbc.OdbcNativeQueryTableValue.GetReaderCore()
    at Microsoft.Mashup.Engine1.Library.Odbc.OdbcNativeQueryTableValue.get_Type()
    at Microsoft.Mashup.Engine1.Runtime.TableValue.Take(RowCount count)
    at Microsoft.Mashup.Engine1.Runtime.WrappingTableValue.Take(RowCount count)
    at Microsoft.Mashup.Engine1.Runtime.DelegatingTableValue.Take(RowCount count)
    at Microsoft.Mashup.Engine1.Runtime.TableValue.Take(Value countOrCondition)
    at Microsoft.Mashup.Engine1.Library.Table.TableModule.Table.FirstNFunctionValue.TypedInvoke(TableValue table, Value countOrCondition)
    at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)
    at Microsoft.Mashup.Engine1.Runtime.FunctionValue.MetaTypeFunctionValue.Invoke(Value arg0, Value arg1)
    at Microsoft.Mashup.Engine1.Runtime.SerializationApplyingModule.SerializableFunctionValue.Invoke(Value arg0, Value arg1)
    at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
    at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame0& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
    at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] args)
    at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Invoke(IValue function, IValue[] arguments)
    at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
    at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
    at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)
    at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
    at Microsoft.Mashup.Evaluator.Firewall.BufferNextPartition(List`1 partitionsToBuffer, Int32 nextPartition, Action`1 callback)
    at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)
    at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)
    at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
    at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
    at Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
    at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
    at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.<CreateThreadStart>b__0(Object o)
    at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)
    --- End of inner exception stack trace ---
    at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass7.<TryReportException>b__6()
    at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
    at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
    at Microsoft.Mashup.Evaluator.EvaluationHost.TryHandleException(Exception exception)
    at Microsoft.Mashup.Evaluator.SafeThread2.HandleException(Exception e)
    at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)
    at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.<CreateThreadStart>b__1(Object o)
    at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
    at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
    --- End of inner exception stack trace ---
    at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
    at Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.Container.OnException(IMessageChannel channel, ExceptionMessage message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
    at Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
    at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
    at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()
    at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()
    at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
    at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
    at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
    at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
    at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
    at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
 
Invocation Stack Trace:
    at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
    at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
    at Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)
    at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
    at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass20.<GetPreviewResult>b__1f()
    at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)
    at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass20.<GetPreviewResult>b__1e(IWorkbook workbook)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClassa.<>c__DisplayClassc.<NotifyGetDataPresence>b__9()
    at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClassa.<NotifyGetDataPresence>b__8(IWorkbook workbook)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClassf.<InvokeOnWorkbook>b__e(IWorkbook workbook, IWindowContext windowContext)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook[T](Func`3 action, T defaultValue)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook(Action`1 action)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.NotifyGetDataPresence(Action`1 action)
    at Microsoft.Mashup.Client.Excel.ExcelDataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
    at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass20.<OnQuerySettingsResolved>b__1d()
    at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
    at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClassf.<Post>b__e(Object null)
    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
    at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
    at System.Delegate.DynamicInvokeImpl(Object[] args)
    at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
    at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
    at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
    at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
    at System.Windows.Forms.Control.WndProc(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
 
 
Supports Premium Content:
TRUE
 
Formulas:
 
 
section Section1;
 
shared Query1 = let
    Source = Odbc.Query("dsn=global_fah", "select top 10 * from inventory_mast")
in
    Source;
 
1 Reply

I have solved the problem.  From Edit Power => Data Source Settings => Global Permissions

then find the data source with the problem, right-click then select Clear Permissions

 

 

@MkeMyers4