CODEWITHSUNDEEP
apiazure-devopspowerbireporting
austinh2o
austinh2o

Reputation: 11

How to create a tabular report from Azure DevOps that includes work item description?

We are trying to use PowerBi to build tabular reports from data in Azure DevOps. In this report, we want to display the description field in one of the table's columns. ADO stores the description as HTML. Neither PowerBI or Excel can render this content, but instead show the markup code. I've also looked at pulling this into python and using Dash with no luck.

There is an extension for ADO that renders html, but it displays a single record and doesn't work as a table cell renderer.

The output I'm looking for is very simple. It is a table (preferably in PowerBI or some other dashboarding tool) that has columns for work item title and description. The description column shows the rendered HTML code as it is displayed in ADO.

Upvotes: 1

Views: 442

Answers (1)

Hugh Lin
Hugh Lin

Reputation: 19461

How to create a tabular report from Azure DevOps that includes work item description?

For this issue, I am afraid this demand is impossible to achieve. It is clearly stated in the document that Description field cannot be used to generate a report.Excel also does not support generating reports on this field.

enter image description here

For details,please refer to this docs. Hope this helps.

Upvotes: 1

Related Questions