Forum Discussion
Create Azure Devops BurnDown chart in PowerBI
Hi All,
I am Trying to create ADO Burn Down chart in PowerBI (By Features) but looks like i am missing the logic. The Screenshot below has Plot burndown by iterations
My Data set has features that are not connect to a fixed iteration but in ADO Burndown widget is able to get the data without the need to assign a feature to a Sprint, when i try using the below query i am unable to replicate the same in PowerBI. Can someone please assist
let
Source = OData.Feed ("https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/WorkItemSnapshot? "
&"$apply=filter( "
&"WorkItemType eq 'User Story' "
&"and startswith(Area/AreaPath,'{areapath}') "
&"and StateCategory ne 'Completed' "
&"and DateValue ge Iteration/StartDate "
&"and DateValue le Iteration/EndDate "
&"and Iteration/StartDate le now() "
&"and Iteration/EndDate ge now() "
&") "
&"/groupby( "
&"(DateValue,State,WorkItemType,Priority,Area/AreaPath,Iteration/IterationPath), "
&"aggregate($count as Count, StoryPoints with sum as TotalStoryPoints) "
&") "
,null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4])
in
Source
Hi Anonymous
Each query contains the following strings that you must substitute with your values. Don't include brackets {} with your substitution. For example if your organization name is "Fabrikam", replace {organization} with Fabrikam, not {Fabrikam}.
- {organization} - Your organization name
- {project} - Your team project name, or omit "/{project}" entirely, for a cross-project query
- {areapath} - Your Area Path. Example format: Project\Level1\Level2
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
3 Replies
Hi Anonymous
Each query contains the following strings that you must substitute with your values. Don't include brackets {} with your substitution. For example if your organization name is "Fabrikam", replace {organization} with Fabrikam, not {Fabrikam}.
- {organization} - Your organization name
- {project} - Your team project name, or omit "/{project}" entirely, for a cross-project query
- {areapath} - Your Area Path. Example format: Project\Level1\Level2
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi Anonymous
Is your issue solved?
If the issue has been solved, please adopt the solution to help others.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi Link,
Yes, i have done all that, i am using with query but replaced all the value accordingly but i am unable to create a burndown report in PowerBI with the query (after replaing variables with my or details).
wanted to check and see if anyone has created the Burndown report in PowerBI sucessfully.