Azure Devops Table Expansion Issues

[Anonymous]

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.

[Powerwoman]

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...")

[Anonymous]

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:

https://docs.microsoft.com/en-us/azure/devops/report/extend-analytics/odata-query-guidelines?view=az...

https://docs.microsoft.com/en-us/azure/devops/report/extend-analytics/data-model-analytics-service?v...

Requesting the community for solutions, not links.

[amitchandak]

@Anonymous , refer if this can help

https://docs.microsoft.com/en-us/azure/devops/report/extend-analytics/odata-query-guidelines?view=az...

https://developercommunity.visualstudio.com/content/problem/900566/odata-feed-connection-from-power-...

https://sqlitybi.com/connecting-power-bi-to-azure-devops-using-odata-feed/?doing_wp_cron=1596613613....

[Anonymous]

Hi Amit, The first link explains what to do and what not to do. It doesn't tell us how to do(join the tables) The other 2 links are irrelevant

[v-zhenbw-msft]

Hi @Anonymous ,

Please refer the following articles.

https://developercommunity.visualstudio.com/content/problem/344694/odata-datasource-error-400-for-bo...

https://docs.microsoft.com/en-us/azure/devops/report/extend-analytics/wit-analytics?view=azure-devop...

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.