upssss.. priority: Minor I have learned trip after trip: 1º - The UI, its the most important key to adopt a new BI Tool ( . . .most importantly, pretty colors) 2º - All the leaders, who decide how to use the money, uses excel (and some of them have a good knowledge about it)
remember: This is a joke based in the real world :) 2016-10-24 15:21 GMT+02:00 Dong Li <lid...@apache.org>: > 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*