How get UserStorie details and Count which are not having linked "Test Case" from ADO into PowerBI

Question

Hi,&nbsp;I want to extract Data from ADO and&nbsp; build a PowerBI dashboard to see the Count of&nbsp; User Stories with Details (ID, State, Title)&nbsp; which are not having "Test Case" linked&nbsp; in PowerBI&nbsp;Can anyone please help me with this query builder?&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details about your tables and your expected output to help us clarify your scenario?
Refer to:
 How to Get Your Question Answered Quickly - Microsoft Power BI Community 
 How to provide sample data in the Power BI Forum - Microsoft Power BI Community 
&nbsp;
Best Regards,Eyelyn Qin

anonymous · Answer

I want to build a Requirement Traceability dashboard in PowerBI which will display how many User-Stories have Test Case as Linked and How many User-Stories do not have Test Case Links.. The Source Data file is ADO

Forum Discussion

How get UserStorie details and Count which are not having linked "Test Case" from ADO into PowerBI

2 Replies

Related content

Title: "Comparing Test Cases Between Different Versions in Power BI"

What does the "connection test" actually do

"ALTER TABLE RENAME TO" does not work with tables in upper casee

PBI Service / Deployment Pipeline "Missing from test"

Slicer to include "open" cases based on start and end date