Search code examples
odataazure-devopspowerbipowerbi-datasource

MultipleLines custom field in VSO does not appear in Power BI report's dataset

I referred the Link to import the data from my VSO into a Power BI report. I'm able to view all the Fields data related to a Work item (ex: title, assigned to, state) in 'WorkItems' table. I'm also able to view the Custom fields data as shown below:

Custom Fields - in report
All the above custom fields in VSO are of type, text(single line), drop down, date etc.

But, i'm unable to find all those custom fields, which are of type "Text (multiple lines)", the fields in VSO which are rich text editors/html type.
enter image description here
How can i get those field values ? Is it not currently supported ?

Solution

  • This is an expected behavior since we don't support Long Text Fields at this time. You can pull the field via VSTS Rest API and then combine them with Analytics Data set in Power BI.

    Check this link for reference: Querying the VSTS Work Items API directly from Power BI.