Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

 

If the default Analytics views and Odata feed cannot meet your need, you can try create a custom Analytics view and connect to it using Azure DevOps connector. Or use OData queries to connect and query the fields you need.

 

Reference:

Use OData queries to generate Power BI reports - Azure DevOps | Microsoft Docs

Tasks & concepts using Data & Analytics - Azure DevOps | Microsoft Docs

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

  • caseylide's avatar
    caseylide
    Frequent Visitor
    4 years ago

    The response doesn't seem to answer the question or address the issue. Here I will try to address the same problem using my own scenario...

    I am already using odata from Power BI to query work items in Azure Devops. The problem is that the query fails whenever I try to retrieve the "Description" field on work items. I can get other fiels such as Title and WorkItemID to return successfully in the odata query, but not the Description field. Why not? How can this be resolved?