Forum Discussion
Azure Devops Table Expansion Issues
Hi,
Has anyone used Azure Devops to join different tables?
I'm trying to expand the already existing records in WorkItems/Areas/Team tables using odata but I get the below error
I'm trying to get a denormalized table that has Team Names, respective Area Names, Tag Names, and Iteration Names.
5 Replies
Anonymous , refer if this can help
Hi Anonymous ,
Please refer the following articles.
And please refer the Common REST API error codes.
https://docs.microsoft.com/en-us/rest/api/storageservices/common-rest-api-error-codes
Here's a blog about 400 bad request for your reference:
https://airbrake.io/blog/http-errors/400-bad-request
If it doesn’t meet your requirement, we suggest you to open a ticket here for help: https://powerbi.microsoft.com/en-us/support/
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I'm struggling to connect a few tables in Azure DevOps. I'm using odata for the same
I'm trying to join Areas, Teams, Iterations, and Tags in a single denormalized table but get the below error:
I have already referred to the below links but they do not offer a solution:
Requesting the community for solutions, not links.
Hi Anonymous,
I was struggling with the same issue.
Here's my solution:Add to your OData.Feed the following 'ingredients', starting with an ?
$Select=WorkItemId,WorkItemType => these are the fields you want to extraxt
$expand=Teams => this is the joined field you want to use (in this case Teams)
Source = OData.Feed("https://analytics.dev.azure.com/*yourCompany*/_odata/WorkItems?$Select=WorkItemId,WorkItemType,Title,State&&$expand=Teams")
