Forum Discussion
Accessing Description in AzureDevops from PowerBI via oData API?
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
Thanks for your reply! I am indeed still looking for a solution to this thread. I will have a look at your idea, try it out, and let you know how it goes.
No problem. As this seems to come up a lot, I decided to write an article on LinkedIn about retrieving the Description and Acceptance Criteria with an end-to-end process for a fictional Azure DevOps organisation and project that might help you on your way. The process would be the same for other work item types also (e.g. Risks, Bugs, etc), but the fields might be slightly different.
Thank you for Sharing this Article, it's really helpful.. am able to retrive the Acceptance Criteria with out any HTML code.. but if acceptance criteria is empty for any of the row.. am getting an error. how to solve this error.
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.
