How to get planned stories in a sprint from Azure devops

[Ghs009]

Hi, 

I am sure this must have been asked multiple times but, I am unable to find the right answer. Can you please help me on how I can get the total number of planned items from ADO in a sprint to power bi ? Is there a way that I don't hardcode the sprints in odata query? Or any other alternative method?

I need a sample query so that I can understand on how to identify planned items in any sprint? 

[amitchandak]

@Ghs009 , refer if this can help

https://stackoverflow.com/questions/61394784/azure-devops-how-to-tell-what-was-planned-in-a-sprint

[Ghs009]

Hi, Thanks for response.

I am looking for powerbi report which lists number of work items planned in a sprint and the number completed.

Is there any query which I can get help with?