Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
All of the sudden, the reports that we had running for months stopped working. I isolated the problem down to this simple query. The table.ExpandRecordColumn is causing the issue. The source data is Dynamcis CRM online using Odata 4.
let Source = OData.Feed(CRMServiceUrl, null, [Concurrent = true, ODataVersion = 4]), opportunities_table = Source{[Name="opportunities",Signature="table"]}[Data], #"Expanded haw_Dealer" = Table.ExpandRecordColumn(opportunities_table, "haw_Dealer", {"address1_city", "name"}, {"haw_Dealer.address1_city", "haw_Dealer.name"}) in #"Expanded haw_Dealer"
Error Message:
Specified method is not supported.
Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> 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.Engine1.Language.Query.Query.get_RowCount()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.