I have connected Azure DevOps to Power BI but having trouble

[aakash2812]

Hello,

I did manage to connect my Azure DevOps Boards to Power BI via Analytic Views, I can see all the information. However, I wanted to see the hierarchy Epic->Feature->User Story->Task and I did try to implement the Path Function using the Work Item Id and the Parent Work Item Id but still on the visual, I cannot see the hierarchy, I want to see a EPIC, and under it I was to see the EPIC name and the details under it

[Anonymous]

just wondering if anyone got a solution to the above?  thank you!

[RahulkumarB123]

hi @aakash2812 did you get the solution for this.. i am having the same issue??

[greekjgg]

Would like to see somebody convert his top image into a matrix like the 2nd image

[amitchandak]

@aakash2812 ,Can you share sample data and sample output in table format?

[aakash2812]

This is how the data should look like, it is coming from Azure DevOps

And this is show it is seen in Power BI