Forum Discussion

Samuele_M's avatar
Samuele_M
Frequent Visitor
2 years ago
Solved

Error when importing workitems table from devops via odata

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]

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

5 Replies

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

    • Samuele_M's avatar
      Samuele_M
      Frequent Visitor

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