Thanks for such amazing content. I have a situation where i want to display attachments for test steps for all test cases to be displayed in powerbi dynamically. Another questions, How to relate test case and test runs in powerbi.
Hi I created a power bi report with analytical view from azure devops..now I an trying to get the Description for all feature items and backlog items. I tried your method but I think I am missing something..please help
Working perfectly - I NEVER would have been able to figure this out without your help, and I love the function capabilities - I never new about that either. Thanks again!
You're very welcome. I had put this off as "too difficult" about 2 years ago. The combination of TH-cam and ChatGpt came through to help figure that final piece of the puzzle out. Appreciate you asking so I had a good reason to go "finally" figure this out.
I'm not sure. I would suggest taking a look at the documentation to see if this is possible to get through the api. If it is then it's possible to get it in power bi. I'll investigate and update this post when I learn more.
Hi, thank you so much for the video! Your style of explaining is very good! I have a question that has caused me some headache that maybe you can have some clever input to. In our company we use DevOps server version and have organised us into several different DevOps projects across the organisation. Some work items are then linked together across projects, with for instance the predecessor/successor link type. I now want to query work items in one project and get information about the linked worked items that are placed in other projects (for instance their status). When using oData it seems we can't get these "remote links" of a WI, instead we only get the local project links. I've seen suggestions that maybe the REST API could support this, is this something you are familiar with?
Hey Ola. Thanks a lot for your feedback. I've come across this question before and like you said I think using the api will work here. Let me do a bit of research and I'll write a comment when I have something. On a side note I have a lot of requests for a video on this topic so will try and prepare something soon (as well)
@paying it Forward, Thanks for this great videos. I have been following your videos lately. Is there a way with which I can create dashboard based on Sprints. Basically, We have a requirement to showcase Sprint tasks on our daily stand up call that makes it easier for manager to present and track team's sprint goals and daily tasks.
Hi - thank you so much for this! It is very helpful. I have a requirement related to the comments field. We have stakeholders who use comments field for clarifications or further actions by tagging specific individuals. I am trying to build a visual that will show me who has the next action items based on this tagging. Do you know how we could extract "tagged names/IDs" from the comments field?
Thanks for your comment. Let me run the flow to extract the comment and see what we get back. I'd hope to be able to parse a user id string and then compare this to the users table we can get from the odata connection. Let me give it a try and I'll update the comment. 👍
Ok so this is what I can see. I used the function I defined on my GitHub to capture the latest comment. When you put a tagged name in the comments field the result comes back like this in Power Query in Power BI: @Peter Maynard - This is just a test to see what shows up here. This means that if you were to for example parse the response on everything that has an @ before it, then you'd be able to isolate the names of specific individuals. I will do a quick video on this one and share it to the channel.
@@PayingItForwardBE thank you for looking into this! It appears "37a8d8fb-7506-64a8-b2ca-9a26176dd394" is the userid, so mapping that to the ADO users table also might work. The approach you mentioned seems more straightforward though. Will keep an eye out for the video. Thanks again :)
This is great, i almost spent countless hours trying to do this. thanks so much
You're welcome! Thanks a lot for the comment.
You're a life saver mate
Appreciate the comment Vincent. Lmk if there is anything else that would help. 👍
Thanks for such amazing content.
I have a situation where i want to display attachments for test steps for all test cases to be displayed in powerbi dynamically.
Another questions, How to relate test case and test runs in powerbi.
Hi I created a power bi report with analytical view from azure devops..now I an trying to get the Description for all feature items and backlog items. I tried your method but I think I am missing something..please help
Awesome! Thank you SO much!
Working perfectly - I NEVER would have been able to figure this out without your help, and I love the function capabilities - I never new about that either. Thanks again!
You're very welcome. I had put this off as "too difficult" about 2 years ago. The combination of TH-cam and ChatGpt came through to help figure that final piece of the puzzle out. Appreciate you asking so I had a good reason to go "finally" figure this out.
Hi, I have a question for you. Can you please explain if we can view the ADO release pipeline results in the PowerBI Release pipeline summary report.
I'm not sure. I would suggest taking a look at the documentation to see if this is possible to get through the api. If it is then it's possible to get it in power bi. I'll investigate and update this post when I learn more.
Hi, thank you so much for the video! Your style of explaining is very good! I have a question that has caused me some headache that maybe you can have some clever input to. In our company we use DevOps server version and have organised us into several different DevOps projects across the organisation. Some work items are then linked together across projects, with for instance the predecessor/successor link type.
I now want to query work items in one project and get information about the linked worked items that are placed in other projects (for instance their status). When using oData it seems we can't get these "remote links" of a WI, instead we only get the local project links. I've seen suggestions that maybe the REST API could support this, is this something you are familiar with?
Hey Ola. Thanks a lot for your feedback. I've come across this question before and like you said I think using the api will work here. Let me do a bit of research and I'll write a comment when I have something. On a side note I have a lot of requests for a video on this topic so will try and prepare something soon (as well)
@paying it Forward, Thanks for this great videos. I have been following your videos lately. Is there a way with which I can create dashboard based on Sprints. Basically, We have a requirement to showcase Sprint tasks on our daily stand up call that makes it easier for manager to present and track team's sprint goals and daily tasks.
Hey Deepak. I've covered this in a new video I just posted yesterday. Hope it helps.👍
Hi - thank you so much for this! It is very helpful. I have a requirement related to the comments field. We have stakeholders who use comments field for clarifications or further actions by tagging specific individuals. I am trying to build a visual that will show me who has the next action items based on this tagging. Do you know how we could extract "tagged names/IDs" from the comments field?
Thanks for your comment. Let me run the flow to extract the comment and see what we get back. I'd hope to be able to parse a user id string and then compare this to the users table we can get from the odata connection. Let me give it a try and I'll update the comment. 👍
@@PayingItForwardBE thanks a ton, will wait for your reply :)
Ok so this is what I can see. I used the function I defined on my GitHub to capture the latest comment.
When you put a tagged name in the comments field the result comes back like this in Power Query in Power BI:
@Peter Maynard - This is just a test to see what shows up here.
This means that if you were to for example parse the response on everything that has an @ before it, then you'd be able to isolate the names of specific individuals. I will do a quick video on this one and share it to the channel.
@@PayingItForwardBE thank you for looking into this! It appears "37a8d8fb-7506-64a8-b2ca-9a26176dd394" is the userid, so mapping that to the ADO users table also might work. The approach you mentioned seems more straightforward though. Will keep an eye out for the video. Thanks again :)