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

[SravanthiKamsal]

Hi,

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?

[v-eqin-msft]

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

[SravanthiKamsal]

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