Forum Discussion
Accessing Description in AzureDevops from PowerBI via oData API?
I am currently using Odata feed in PowerBI power query to access User Stories and their fields from Azure Devops in order to build reporting. I am unable to access the 'description' field using the O...
Not sure if anyone is still looking for this, but you can get this as follows:
let
GetDocument = Json.Document(VSTS.Contents("https://dev.azure.com/{your Azure DevOps org}/{your project}/_apis/wit/workitems/{id}")),
ConvertToTable = Record.ToTable(GetDocument[fields])
in
ConvertToTable
Replace {your Azure DevOps org}, {your project} and {id} as applicable.
You end up with something like this:
Transposing the table, promoting the first row as headers, and additional transformations will give you the info you need.
ferryv wondering how to get a table of all the latest workitem data rather than having to specify a single workitem ID?
The standard odata feed provides all info in a project, so depening on what you require, that might be sufficent. See also: https://learn.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops.
The standard feed does not retrieve longtext fields (Description, Acceptance Criteria, etc). The article referenced in one of the provious comments provide and end-to-end solution via a loop.