The specified type member 'Field Name' is not supported in LINQ to Entities.

[Anonymous]

I had a working query in the Data Flow, which started giving me the following error last Friday:

DataSource.Error: OData: Request failed: The remote server returned an error: (500) Internal Server Error. (The specified type member 'Custom11' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.)DetailsDataSourceKind = OData
DataSourcePath = https://analytics.dev.azure.com/vfuk-digital/Digital/_odata/v3.0-preview/WorkItems
Url = https://analytics.dev.azure.com/vfuk-digital/Digital/_odata/v3.0-preview/WorkItems

The query looks like this:

let
  columnlist = {"WorkItemId", "IterationSK", "AreaSK", "AssignedToUserSK", "Title", "WorkItemType", "CreatedDate", "State", "ActivatedDate", "ClosedDate", "Priority", "StoryPoints", "CommentCount", "Custom_BlockedDate", "Custom_BlockedLeavingDate", "Custom_BlockedReason", "Custom_Success", "Custom_SpillOverReason", "VFDigitalAgile_AreaofValue", "VFDigitalAgile_Environment"},
  projecturl = "ProjectURL",
  Source = OData.Feed("https://analytics.dev.azure.com/vfuk-digital/" & projecturl & "/_odata/v3.0-preview", null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4]),
  #"Filtered rows" = Table.SelectRows(Source, each [Name] = "WorkItems"),
  #"Removed columns" = Table.RemoveColumns(#"Filtered rows", {"Name", "Signature"}),
  #"Expanded Data" = Table.ExpandTableColumn(#"Removed columns", "Data", columnlist, columnlist),
  #"Filtered rows2" = Table.SelectRows(#"Expanded Data", each [CreatedDate] > #datetimezone(2019, 2, 1, 0, 0, 0, 0, 0)),
  #"Changed column type" = Table.TransformColumnTypes(#"Filtered rows2", {{"Priority", Int64.Type}, {"StoryPoints", Int64.Type}, {"CommentCount", Int64.Type}, {"Custom_BlockedDate", type datetime}, {"Custom_BlockedLeavingDate", type datetime}, {"ClosedDate", type datetime}, {"ActivatedDate", type datetime}, {"CreatedDate", type datetime}, {"WorkItemType", type text}, {"State", type text}, {"Custom_SpillOverReason", type text}, {"VFDigitalAgile_AreaofValue", type text}, {"VFDigitalAgile_Environment", type text}, {"Custom_BlockedReason", type text}, {"Title", type text}, {"AssignedToUserSK", type text}, {"AreaSK", type text}, {"IterationSK", type text}, {"WorkItemId", type text}}),
  #"Removed duplicates" = Table.Distinct(#"Changed column type", {"WorkItemId", "IterationSK", "AreaSK", "AssignedToUserSK", "Title", "WorkItemType", "CreatedDate", "State", "ActivatedDate", "ClosedDate", "Priority", "StoryPoints", "CommentCount", "Custom_BlockedDate", "Custom_BlockedLeavingDate", "Custom_BlockedReason", "Custom_Success", "Custom_SpillOverReason", "VFDigitalAgile_AreaofValue", "VFDigitalAgile_Environment"}),
  #"Transform columns" = Table.TransformColumnTypes(#"Removed duplicates", {{"Custom_Success", type text}}),
  #"Replace errors" = Table.ReplaceErrorValues(#"Transform columns", {{"Custom_Success", null}})
in
  #"Replace errors"

I also tried a simplefied version, with the same 500 error:

let
  projecturl = "ProjectURL",
  Source = OData.Feed("https://analytics.dev.azure.com/vfuk-digital/" & projecturl & "/_odata/v3.0-preview", null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4]),
  Navigation = Source{[Name = "WorkItems", Signature = "table"]}[Data]
in
  Navigation

Any thoughts?

[Akshay94]

Hey, this issue is known to the AzureDevOps Reporting team. We are working to fix this. I will update once deployment for this has been done. As a quick resolution, you can try to run after removing any new column added by you in the query recently.

[Anonymous]

Ok, thanks. I haven't done any changes to the query. Mayhaps somone from the devops added neew fields.

[Akshay94]

Can you please check and let us know if things are working fine now?

[Anonymous]

It's refreshing 🙂 Thank you Microsoft ❤️ 

[otravers]

It looks like an error produced by the code generating your Odata feed (an in-house Azure Functions script?). What happens when you load your Azure URL in a browser? Speaking of which, you might want to obfuscate the Azure URLs in your post.

[Anonymous]

Thanks for your asnwer. The link works fine in the PQ as well as in the browser. That's not when the error happens.
The error happens after the 
#"Expanded data" step in the first query and Navigation step in the second one.