Showing results for 
Search instead for 
Did you mean: 

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



I want to extract Data from ADO and  build a PowerBI dashboard to see the Count of  User Stories with Details (ID, State, Title)  which are not having "Test Case" linked  in PowerBI


Can anyone please help me with this query builder?


Community Support
Community Support

Hi @SravanthiKamsal ,


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


Best Regards,
Eyelyn Qin

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

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors