Forum Discussion
Samuele_M
2 years agoFrequent Visitor
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 co...
- 2 years ago
You may want to first try with a (much) smaller subset of columns.
lbendlin
2 years agoSuper User
You may want to first try with a (much) smaller subset of columns.
Samuele_M
2 years agoFrequent Visitor
even if import only a signle column when i try to refresh preview in power query it gives me the same error
- lbendlin2 years agoSuper User
can you show the new code?
- Samuele_M2 years agoFrequent Visitor
when i import this it shows me data but when i try to refresh it gives me the same error:
- Samuele_M2 years agoFrequent Visitor
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"])