topic Re: Error when importing workitems table from devops via odata in Developer

Error when importing workitems table from devops via odata

Samuele_M — Thu, 02 May 2024 08:29:22 GMT

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 — Thu, 02 May 2024 22:38:31 GMT

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

Samuele_M — Fri, 03 May 2024 09:01:25 GMT

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

lbendlin — Fri, 03 May 2024 14:42:20 GMT

can you show the new code?

Samuele_M — Mon, 06 May 2024 08:35:48 GMT

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

Samuele_M — Tue, 07 May 2024 08:04:55 GMT

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