Generating QA Report based on Integration Build

[Anonymous]

I want to generate a QA Test Status report using Power BI desktop. The search criteria should be based on Integration Build.

I have tried using Odata Feed & query but no luck.

Followed below link for Pipeline based report

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-stories-overview?view=azure-devo...

And for Test Plan based report

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-test-plans-progress-status?view=...

but unable to link the WorkItemId under given Integration build so that Test Status Report can be generated. 

Please find below report format, I need to link WorkItemId with the Test Points & Test 

[v-eachen-msft]

Hi @Anonymous ,

Maybe you could refer to this document:

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-boards-directlinks?view=azure-devops&tabs=powerbi

[Anonymous]

Hi @v-eachen-msft ,

Thanks for the response.

I have tried this solution but this will generate based on Area Path. To be specific, I need to generate the report based on given Integration Build Number all the associated user stories integrated under that build, and linked Test execution results.