jeje Yes, The new version of Microsoft Power BI is not working with Kylin ..... :( See this video <https://youtu.be/v9of5N3TcTw> mailLIst (you can see ScreenShoots) <http://mail-archives.apache.org/mod_mbox/kylin-user/201609.mbox/%3CCAEcyM16%3Dd9%2Bdc5equz8pFUowEQg3ntsPm0_Goe%3DoBBTLKtQg%3DQ%40mail.gmail.com%3E>
After 3 days testing and view logs, ... I cant solved it I discoverd this: > > Query with *limit 5*, the preview data run OK, but load data ... never > > finished > > 2016-10-21 9:17 GMT+02:00 Bhanu Prakash Sunkesula <bps.sunkes...@gmail.com>: > Hi all, > > I am unable to load data from KYLIN CUbe to Excel / power BI, > i have installed all required drivers ( Microsoft Visual C++ 2012 > Redistributable > <http://www.microsoft.com/en-us/download/details.aspx?id=30679> & KYLIN > ODBC drivers ). i am able to connect successfully to KYLIN CUBE, but the > data is not loading to excel / power BI because of below issue and also > some dimensions are not showing up in Excel. > > Error Message: > > Value was either too large or too small for an Int32. > > Stack Trace: > > Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either too > large or too small for an Int32. ---> > Microsoft.Mashup.Evaluator.Interface.ErrorException: > Value was either too large or too small for an Int32. ---> > Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either too > large or too small for an Int32. ---> > Microsoft.Mashup.Evaluator.Interface.ErrorException: > Value was either too large or too small for an Int32. ---> > Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either too > large or too small for an Int32. ---> System.OverflowException: Value was > either too large or too small for an Int32. ---> System.OverflowException: > Value was either too large or too small for an Int32. > at System.Convert.ToInt32(Int64 value) > at System.Int64.System.IConvertible.ToInt32(IFormatProvider provider) > at System.Convert.ToInt32(Object value, IFormatProvider provider) > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection.< > EnsureInitialized>b__0(IOdbcConnection connection) > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<> > c__DisplayClassf.<Connect>b__e(IOdbcConnection connection) > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<> > c__DisplayClassc`1.<Connect>b__b() > at > Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 > maxRetryAttempts, Func`1 action) > at Microsoft.Mashup.Engine1.Library.Common. > DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action) > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.Connect[T](String > currentCatalog, Func`2 func) > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.Connect(Action`1 > action) > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection. > EnsureInitialized() > at > Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryDomain.NewQuery(OdbcTableInfo > table, List`1 fromItems) > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTableValue. > OdbcTableValueBuilder.CreateTableValue(OdbcTableInfo tableInfo) > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcHierarchicalNavigationTabl > eValue.<>c__DisplayClass9.<CreateOdbcTable>b__8() > at Microsoft.Mashup.Engine1.Runtime.DelayedValue.get_Value() > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcHierarchicalNavigationTabl > eValue.OdbcTableLevelNavigationTableValue.<>c__DisplayClass1f.<NewLazyRow>b__1d(Int32 > i) > at Microsoft.Mashup.Engine1.Runtime.RecordValue. > DemandRecordValue.get_Item(Int32 index) > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) > at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(Value > frame) > at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value > frame) > at > Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value > frame) > at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value > frame) > at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value > arg0) > at > Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 > index) > at Microsoft.Mashup.Engine1.Language.RecordExpression. > RuntimeRecordValue.get_Item(Int32 index) > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) > at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(Value > frame) > at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value > arg0) > at > Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 > index) > at Microsoft.Mashup.Engine1.Language.RecordExpression. > RuntimeRecordValue.get_Item(Int32 index) > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(Value key) > at Microsoft.Mashup.Engine1.Runtime.Library.Linker. > BindFunctionValue.TypedInvoke(RecordValue environment, Value section, > TextValue name) > at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value > arg0, Value arg1, Value arg2) > at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] args) > at > Microsoft.Mashup.Engine1.Language.ExpressionInvocationExpression.Execute(MembersFrame0& > frame) > at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke() > at > Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.Force(Int32 > index) > at Microsoft.Mashup.Engine1.Language.ListExpression. > RuntimeListValue.get_Item(Int32 index) > at Microsoft.Mashup.Engine1.Runtime.ListValue.get_Item(Value key) > at Microsoft.Mashup.Engine1.Runtime.Library.List. > ElementWithListCheckFunctionValue.Invoke(Value collection, Value key) > at > Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(MembersFrame1& > frame) > at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value > arg0) > at > Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 > index) > at Microsoft.Mashup.Engine1.Language.RecordExpression. > RuntimeRecordValue.get_Item(Int32 index) > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) > at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(Value > frame) > at > Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value > frame) > at Microsoft.Mashup.Engine1.Language.Expression.ExecuteCondition(Value > frame) > at Microsoft.Mashup.Engine1.Language.DebugExpression.ExecuteCondition(Value > frame) > at Microsoft.Mashup.Engine1.Language.IfExpression.Execute(Value frame) > at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value > frame) > at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value > arg0) > at > Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 > index) > at Microsoft.Mashup.Engine1.Language.RecordExpression. > RuntimeRecordValue.get_Item(Int32 index) > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) > at > Microsoft.Mashup.Engine1.Language.FieldAccessExpression.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) > --- End of inner exception stack trace --- > 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) > 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.Interface.EvaluationResult2`1. > get_Result() > at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__ > DisplayClass1.<BeginGetResult>b__0(EvaluationResult2`1 result) > --- End of inner exception stack trace --- > at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__ > DisplayClass1.<BeginGetResult>b__0(EvaluationResult2`1 result) > 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) > 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.Interface.EvaluationResult2`1. > get_Result() > at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator. > Service.<>c__DisplayClass15.<>c__DisplayClass17.< > OnBeginGetPreviewValueSource>b__14() > at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__ > DisplayClass5.<RunStub>b__3() > at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace > trace, IEngineHost engineHost, IMessageChannel channel, Action action) > --- End of inner exception stack trace --- > at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass7.< > TryReportException>b__6() > at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IHostTrace > trace, Action action) > at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace > trace, IEngineHost engineHost, IMessageChannel channel, Exception exception) > at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace > trace, IEngineHost engineHost, IMessageChannel channel, Action action) > at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost > engineHost, IMessageChannel channel, Func`1 getPreviewValueSource) > at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator. > Service.<>c__DisplayClass15.<OnBeginGetPreviewValueSource>b__13(EvaluationResult2`1 > result) > at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator. > Service.<>c__DisplayClass28`1.<OnBeginGetResult>b__25() > at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace > trace, IEngineHost engineHost, IMessageChannel channel, Action action) > 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) > 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.RemoteEvaluationContainerFacto > ry.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.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_Value() > at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource. > get_Value() > at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource. > get_Value() > at Microsoft.Mashup.Host.Document.Preview.PreviewEvaluation.<>c__ > DisplayClassb.<StartEvaluation>b__8(EvaluationResult2`1 result) > > Invocation Stack Trace: > > at Microsoft.Mashup.Host.Document.ExceptionExtensions. > GetCurrentInvocationStackTrace() > at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String > exceptionStackTrace, String invocationStackTrace) > at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String > message, Nullable`1 errorCode, String requestId, Exception exception) > at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<> > c__DisplayClass1.<HandleException>b__0() > at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio > ns.SendAndMarshalExceptions(SynchronizationContext context, Action > callback) > at > Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception > e) > at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm. > DelayedInitializationExceptionHandler.HandleException(Exception e) > at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm.<>c__ > DisplayClass6.<OnAjaxException>b__5() > at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions. > HandleExceptions(IExceptionHandler exceptionHandler, Action action) > at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio > ns.<>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) > at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) > at > System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form > form) > at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 > reason, ApplicationContext context) > at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 > reason, ApplicationContext context) > at System.Windows.Forms.Application.RunDialog(Form form) > at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) > at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T > form, IWin32Window owner) > at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm.ShowDialog(IWin32Window > owner) > at Microsoft.Mashup.Client.ClientShared.Ux.FloatingDialog. > NavigatorFloatingDialog.ShowEditLoadTo(IWin32Window owner, WindowsHost > windowsHost, Query query, ITelemetryService telemetryService) > at Microsoft.Mashup.Client.Excel.ExcelDataImporter.ShowNavigator(Query > query) > at Microsoft.Mashup.Client.ClientShared.DataImporter. > ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& importedQueries) > at > Microsoft.Mashup.Client.ClientShared.DataImporter.ImportNavigationSource(Query > query) > at Microsoft.Mashup.Client.ClientShared.DataImporter. > OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, > String formulaTitle, Nullable`1 explicitImportDestination, Boolean > isNewQuery, Boolean isFromEditor) > at Microsoft.Mashup.Client.ClientShared.DataImporter.<>c_ > _DisplayClass1d.<OnQuerySettingsResolved>b__1a() > at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions. > HandleExceptions(IExceptionHandler exceptionHandler, Action action) > at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio > ns.<>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) > > [image: Inline image 1] > > > > Thanks & Regards, > *Bhanu Prakash Sunkesula*. > +91 *7795395099 <7795395099>* >