Mar 02 2020 01:11 PM
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; |
Mar 03 2020 07:47 AM
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