Error when importing workitems table from devops via odata

[Samuele_M]

i'm importing tables from devops in powerbi via odata. I'm not able to import workitems table; the error it gives me is the following:

every other table from the same connection is imported correctly. Does someone has any idea on how to solve this issue?

this is the m script:

"let
Source = OData.Feed("https://analytics.dev.azure.com/my_organization/_odata/v1.0/", null, [Implementation="2.0"]),
WorkItems_table = Source{[Name="WorkItems",Signature="table"]}[Data]

[lbendlin · Accepted solution]

You may want to first try with a (much) smaller subset of columns.

[Samuele_M]

even if import only a signle column when i try to refresh preview in power query it gives me the same error

[lbendlin]

can you show the new code?

[Samuele_M]

when i import this it shows me data but when i try to refresh it gives me the same error:

[Samuele_M]

it worked selecting only the columns i was using for the report using a select directly in the url:

Source = OData.Feed("https://analytics.dev.azure.com/myorg/_odata/v1.0/WorkItems?$select=WorkItemId", null, [Implementation="2.0"])