Unable to retrieve more than 8 tags of a test case from Azure DevOps in Power BI

[IOG]

Unable to retrieve more than 8 tags of a test case from Azure DevOps in Power BI

Ben in another topic had to manually add and remove a new tag in order to see the tags but that is not working for me as I see only 8 tags even that the test case had more than 8 tags. This is an integration issues/limitation in the integration with Azure DevOps from Power BI. Azure DevOps sees all tags but Power BI sees only firt 8. Please help.

[v-bmanikante]

Hi @IOG,

we would like to follow up to see if the solution provided by the super user/CST resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
B Manikanteswara Reddy

[IOG · Accepted solution]

Managed to create an Analytics views (Boards only) in Azure DevOps portal (configured to include the Tags column) and use that one in PowerBI by navigating to Get data / Online Services / Azure DevOps (Boards only) option. This option is showing all my tags and I can use them to create custom columns as needed. (So far I can see more then 10 tags that is exceding previous OData feed limitation of 8 tags)

Thank you for your support!

[IOG]

Sorry my delayed response. Was busy with othe work and plan on trying the WEB connector this week and let you know the result. Hope I can connec the WEB connector with the OData.

[v-bmanikante]

Hi @IOG ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @IOG,

we would like to follow up to see if the solution provided by the super user/CST resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
B Manikanteswara Reddy

[IOG]

Unfortunatelly I do not see the "Azure DevOps REST API" option in Power BI when I try the "Get Data" options. I see "Azure DevOps (Boards only)" and "Azure DevOps Server (Boards only)"

Is there another way I can integrate "Azure DevOps REST API" with Power BI?

[v-bmanikante]

Hi @IOG ,

Apologies for the delay in getting back to you

Thanks for the update!

You're right — the Azure DevOps REST API isn’t listed as a built-in connector under Get Data in Power BI. But the good news is: you can still connect to it using the “Web” connector and custom queries.

Here’s how you can use the Azure DevOps REST API in Power BI:

Steps to Use Azure DevOps REST API in Power BI:

Power BI Desktop>Go to Home > Get Data > Web

Choose Advanced (instead of Basic)

In the URL field, paste your REST API call, for example:

https://dev.azure.com……….

If needed, add headers (like "Authorization" with a Personal Access Token) by enabling Advanced options.

Click OK and Power BI will pull the data.

-->You’ll need a Personal Access Token (PAT) from Azure DevOps to authenticate. You can generate one by following this guide:

Use personal access tokens - Azure DevOps | Microsoft Learn

You can refer the below documentation for more details:
Get started with the REST APIs for Azure DevOps Services and Azure DevOps Server - Azure DevOps Serv...

Connect to a webpage from Power BI Desktop - Power BI | Microsoft Learn

If you're still experiencing this issue even after trying the REST API workaround, I recommend raising a support ticket with Microsoft. The support team can investigate further on the backend and provide more targeted help for your specific environment.

https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-prasare]

Hi @IOG,

Thanks for reaching out to Fabric community support.

Power BI retrieves data via the OData feed but it has some limitations on tags. Instead of using default OData feed, you can try to use the Azure DevOps REST API to fetch all tags from test case data.

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[BeaBF]

@IOG Hi! 

You're facing a known limitation with the Azure DevOps OData feed (which is what Power BI uses to pull data from Azure DevOps). Unfortunately, the Tags field in Azure DevOps' OData API is a multi-value string field, but in the OData feed, it gets flattened and truncated — by default, it only returns up to 8 tags per work item/test case.

This is a design limitation in Microsoft's current OData implementation for Azure DevOps, not something you can fix from Power BI side alone.
It's also not related to any "manual refresh" trick like adding/removing tags; the API literally only exposes the first 8 tags in the feed.

Use Azure DevOps REST API instead of OData Feed.

BBF