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.
