Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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...")
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |