https://community.fabric.microsoft.com/t5/Developer/ODATA-query-azure-devops/m-p/2341295#M34430 <P>Hi&nbsp;@Anonymous</a>&nbsp;,</P> <P>Without information about the Azure Devops environment you are using, there is no way to provide you with the right solution. Maybe you can try to raise a case in GITHUB under Azure Devops directory to get more professional help.</P> <P><A href="https://github.com/MicrosoftDocs/azure-devops-docs/blob/main/docs/report/powerbi/sample-boards-rollup.md" target="_self">Rollup child work item values to parent sample report</A><BR />In addition, for the substitution of <SPAN>User Story</SPAN>, you can check the value of <EM><STRONG>Work Item Type</STRONG></EM> circled in <STRONG><FONT color="#FF0000">red</FONT> </STRONG>in the screenshot below and replace the <SPAN>User Story</SPAN> with that value...</P> <P><A href="https://colinsalmcorner.com/work-item-hierarchy-reports-in/" target="_self">Azure DevOps Work Item Hierarchy Reports in PowerB</A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="yingyinr_0-1644993355027.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/670545iD8E1B0BE0A822A30/image-size/large?v=v2&amp;px=999" role="button" title="yingyinr_0-1644993355027.png" alt="yingyinr_0-1644993355027.png" /></span></P> <P>Best Regards</P> Wed, 16 Feb 2022 06:40:49 GMT Anonymous 2022-02-16T06:40:49Z https://community.fabric.microsoft.com/t5/Developer/ODATA-query-azure-devops/m-p/2335535#M34369 <P>I am trying to bring data into power bi through a blank query following this link&nbsp;<A href="https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-boards-rollup?view=azure-devops&amp;tabs=powerbi" target="_blank" rel="noopener">Rollup child work item values to sample report - Azure DevOps | Microsoft Docs</A></P><P>&nbsp;</P><P>The devops environment i am using has different names for User Story (Product Backlog Item) and Story Points (tasks). Does anyone know what i would need to substitute in the query to get it to work?&nbsp;</P><P><BR />Thanks!</P> Mon, 14 Feb 2022 00:57:08 GMT https://community.fabric.microsoft.com/t5/Developer/ODATA-query-azure-devops/m-p/2335535#M34369 Anonymous 2022-02-14T00:57:08Z https://community.fabric.microsoft.com/t5/Developer/ODATA-query-azure-devops/m-p/2341295#M34430 <P>Hi&nbsp;@Anonymous</a>&nbsp;,</P> <P>Without information about the Azure Devops environment you are using, there is no way to provide you with the right solution. Maybe you can try to raise a case in GITHUB under Azure Devops directory to get more professional help.</P> <P><A href="https://github.com/MicrosoftDocs/azure-devops-docs/blob/main/docs/report/powerbi/sample-boards-rollup.md" target="_self">Rollup child work item values to parent sample report</A><BR />In addition, for the substitution of <SPAN>User Story</SPAN>, you can check the value of <EM><STRONG>Work Item Type</STRONG></EM> circled in <STRONG><FONT color="#FF0000">red</FONT> </STRONG>in the screenshot below and replace the <SPAN>User Story</SPAN> with that value...</P> <P><A href="https://colinsalmcorner.com/work-item-hierarchy-reports-in/" target="_self">Azure DevOps Work Item Hierarchy Reports in PowerB</A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="yingyinr_0-1644993355027.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/670545iD8E1B0BE0A822A30/image-size/large?v=v2&amp;px=999" role="button" title="yingyinr_0-1644993355027.png" alt="yingyinr_0-1644993355027.png" /></span></P> <P>Best Regards</P> Wed, 16 Feb 2022 06:40:49 GMT https://community.fabric.microsoft.com/t5/Developer/ODATA-query-azure-devops/m-p/2341295#M34430 Anonymous 2022-02-16T06:40:49Z