0
Votar
Presentado por
MFMCRM
sobre
07-04-2017
05:56
Tengo una tabla con una columna que quiero expandir para obtener otra columna interna. Esto funcionó correctamente hasta la última actualización, pero ahora aparece el siguiente error:
Feedback Type: Frown (Error) Timestamp: 2017-07-04T12:40:51.1444899Z Local Time: 2017-07-04T14:40:51.1444899+02:00 Product Version: 2.47.4766.801 (PBIDesktop) (x64) Release: June 2017 IE Version: 11.1358.14393.0 OS Version: Microsoft Windows NT 10.0.14393.0 (x64 es-ES) CLR Version: 4.6.2. or later [Release Number = 394802] Workbook Package Info: 1* - es-ES, Query Groups: 2, fastCombine: Disabled, runBackgroundAnalysis: True. Peak Working Set: 752 MB Private Memory: 901 MB Peak Virtual Memory: 35.2 GB Error Message: Specified method is not supported. Stack Trace: Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported. at Microsoft.Mashup.Engine1.Library.OData.V4.ODataExpression.VisitColumnAccess(ColumnAccessQueryExpression expression) at Microsoft.Mashup.Engine1.Library.OData.V4.ODataColumns..ctor(RecordTypeValue recordTypeValue, Capabilities capability, IEdmEntityType entityType, ODataEnvironment environment) at Microsoft.Mashup.Engine1.Library.OData.V4.ODataQuery..ctor(ODataEnvironment environment, IEdmNavigationSource navigationSource, ODataPath path, IEdmNamedElement namedElement, IEdmEntityType entityType, RecordTypeValue recordTypeValue, Boolean isComposable, Boolean allColumnsSelected, Uri baseUri) at Microsoft.Mashup.Engine1.Library.OData.V4.ODataQuery..ctor(ODataEnvironment environment, IEdmNavigationProperty navigationProperty, IEdmNavigationSource navigationSource, RecordTypeValue recordTypeValue, Uri baseUri) at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.CreateEntryLinkValue(NavigationLinkWrapperPropertyLookupValue lookupValue, TypeValue fieldType, Int32 column) at Microsoft.Mashup.Engine1.Library.OData.ODataStructuralValueConverter.<>c__DisplayClass1f`1.<CreateEntryValue>b__1b(String key, Int32 i) at System.Linq.Enumerable.<SelectIterator>d__5`2.MoveNext() at System.Linq.Buffer`1..ctor(IEnumerable`1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at Microsoft.Mashup.Engine1.Library.OData.ODataStructuralValueConverter.CreateEntryValue[TODataException](ODataEnvironmentBase environment, TypeValue type, IEnumerable`1 properties, Dictionary`2 links, Func`4 createEntryLinkValueReference, Func`2 marshalFromClr, ODataEntry entry, IEdmEntitySetBase entryEntitySet) at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.CreateEntryValue(TypeValue type, ODataEntry entry, IEdmNavigationSource entryEntitySet, Dictionary`2 links) at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.<>c__DisplayClassc.<ReadEntryFromLink>b__8(TypeValue type) at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.CreateEntryLinkValue(NavigationLinkWrapperPropertyLookupValue lookupValue, TypeValue fieldType, Int32 column) at Microsoft.Mashup.Engine1.Library.OData.ODataStructuralValueConverter.<>c__DisplayClass1f`1.<CreateEntryValue>b__1b(String key, Int32 i) at System.Linq.Enumerable.<SelectIterator>d__5`2.MoveNext() at System.Linq.Buffer`1..ctor(IEnumerable`1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at Microsoft.Mashup.Engine1.Library.OData.ODataStructuralValueConverter.CreateEntryValue[TODataException](ODataEnvironmentBase environment, TypeValue type, IEnumerable`1 properties, Dictionary`2 links, Func`4 createEntryLinkValueReference, Func`2 marshalFromClr, ODataEntry entry, IEdmEntitySetBase entryEntitySet) at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.CreateEntryValue(TypeValue type, ODataEntry entry, IEdmNavigationSource entryEntitySet, Dictionary`2 links) at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.MoveNext() at Microsoft.Mashup.Engine1.Library.OData.V4.BatchEnumerator.ReadPage() at Microsoft.Mashup.Engine1.Library.OData.V4.BatchEnumerator.MoveNext() at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count) at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue() at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue() 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(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.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__DisplayClass1e`1.<OnBeginGetResult>b__1b() 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.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.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.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(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.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_SmallValue() at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue() 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.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.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) 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.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) 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.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner) at Microsoft.PowerBI.Client.Program.<>c__DisplayClassd.<Main>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.Main(String[] args)
Otras tablas con columnas en expansión funcionan correctamente.
Estado: Aceptado
v-haibl-msft
@MFMCRM
Este problema ya se ha informado internamente al equipo de Power BI: CRI 41055395
Publicaré aquí una vez que reciba alguna actualización al respecto.
Atentamente,
Herbert
Vicky_Song
Estado cambiado a: Aceptado
MFMCRM
Gracias
v-haibl-msft
@MFMCRM
Actualmente, puede probar con la siguiente solución, pero puede tener implicaciones negativas en el rendimiento. Reemplace el inicio de una consulta que se vea así:
dejar
Fuente = OData.Feed(«https://unimelbedu.api.crm6.dynamics.com/api/data/v8.1/«),
leads_table = Fuente{[Name=»leads»,Signature=»table»]}[Data],
Con una consulta que se ve así:
dejar
tabla_clientes = OData.Feed(«https://theelderscrolls.crm4.dynamics.com/api/data/v8.1/leads?$select=*«)
Es decir, mueva el nombre del conjunto de entidades a la URL de OData y agregue una opción de consulta para seleccionar todos los campos. Lo que esto hará es obligar a todos los pasos posteriores a operar localmente en lugar de ejecutarse en el servidor, razón por la cual el rendimiento puede verse afectado. Pero también debería evitar el error que impide que se ejecute la consulta.
Atentamente,
Herbert
4 comentarios (4 nuevos)