Thanks Alberto, I created JIRA to track this: https://issues.apache.org/jira/browse/KYLIN-2121
Thanks, Dong Li Original Message Sender:Alberto Ramóna.ramonporto...@gmail.com Recipient:dev...@kylin.apache.org Date:Monday, Oct 24, 2016 20:31 Subject:Re: Unable to pull data from Kylin Cube ( learn_kylin cube ) to Excelor Power BI for Visualization and some dimensions are not showing up. To reproduce, you can use this video https://www.youtube.com/watch?v=v9of5N3TcTwfeature=youtu.be and kylin cube example: select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt (The load data process never will finisfh, as in video, but you can see Error in log "Value was either too large or too small for an Int32" ) 2016-10-23 15:06 GMT+02:00 Luke Han luke...@gmail.com: Please help to create one JIRA for this issue, we will follow up for the root cause and try to fix it if possible. Thanks. Best Regards! --------------------- Luke Han On Sat, Oct 22, 2016 at 4:41 AM, Alberto Ramón a.ramonporto...@gmail.com wrote: 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. EnsureInitializedb__0(IOdbcConnection connection) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource. c__DisplayClassf.Connectb__e(IOdbcConnection connection) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource. c__DisplayClassc`1.Connectb__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.CreateOdbcTableb__8() at Microsoft.Mashup.Engine1.Runtime.DelayedValue.get_Value() at Microsoft.Mashup.Engine1.Library.Odbc. OdbcHierarchicalNavigationTabl eValue.OdbcTableLevelNavigationTableValue.c__DisplayClass1f. NewLazyRowb__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.AddHandlerb__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.AddHandlerb__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. CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__ DisplayClass15.CreateActionb__14(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2. CreateThreadStartb__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.BeginGetResultb__0(EvaluationResult2`1 result) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.c__ DisplayClass1.BeginGetResultb__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.AddHandlerb__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.AddHandlerb__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. CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__ DisplayClass15.CreateActionb__14(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2. CreateThreadStartb__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. OnBeginGetPreviewValueSourceb__14() at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.c__ DisplayClass5.RunStubb__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. TryReportExceptionb__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.OnBeginGetResultb__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.AddHandlerb__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.AddHandlerb__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. CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__ DisplayClass15.CreateActionb__14(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2. CreateThreadStartb__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.AddHandlerb__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.StartEvaluationb__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.HandleExceptionb__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.OnAjaxExceptionb__5() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions. HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio ns.c__DisplayClassf.Postb__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.OnQuerySettingsResolvedb__1a() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions. HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio ns.c__DisplayClassf.Postb__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*