From Azure DevOps to Power BI: Crafting Dashboards for Stakeholders
HTML-код
- Опубликовано: 13 авг 2023
- NEW - Sample Power BI Report Template - github.com/lilepeeps/shared_f...
Download Power BI Desktop: - powerbi.microsoft.com/en-us/d...
Structure for Odata feed connection: analytics.dev.azure.com/[Your Azure DevOps Organization]/[Your Project Name]/_odata/v3.0-preview
e.g. analytics.dev.azure.com/Org/P...
Dive into connecting Azure DevOps data and Power BI in this comprehensive guide!
While Azure DevOps is a powerful tool for project management teams, not all stakeholders are familiar with its intricacies. That's where Power BI steps in, transforming intricate project data into clear, navigable dashboards.
This video takes you step-by-step through the process of:
- Connecting Azure DevOps data to Power BI Desktop.
- Refining and focusing your data to spotlight only essential details.
- Building valuable data relationships for deeper insights.
- Designing interactive and engaging dashboards tailored for decision-makers.
If you've ever wanted to enhance project transparency and communication with leadership through captivating visuals, this tutorial is for you.
Beautiful Power BI Designs Channels
/ @howtopowerbi
/ @guyinacube
#AzureDevOps #PowerBI #DashboardDesign #DataVisualization #StakeholderCommunication #ProjectManagement #PowerBIDesktop #DataRelationships #AzureDevOpsToPowerBI #DataTransformation #DecisionMaking #interactivedashboards
Chapters:
00:02 - Introduction
00:43 - What we'll cover today
01:09 - How to connect your Azure DevOps Data to Power BI
05:28 - Building Power BI visuals
07:05 - Developing relationships in your data
07:53 - Finishing building our dashboard
09:41 - Summary
10:37 - Close
Love your videos, your style and approach. Just shared your channel with my team of Design Strategists.
Thanks so much for the comment. It's really appreciated! If you have any suggestions for a future videos, please don't hesitate to let me know. Peter
Excellent video focused on the topic.
Much appreciated! Thanks for your feedback. Let me know if there's anything else you'd like me to cover on this topic.
@@PayingItForwardBE Thanks. I tried it and had some questions - the pipelines tabel seems to bring only the build pipelines. Any possibility to get the release pipelines? Also, the branches table looks empty for me. Is it possible to bring data about repos and branches?
Will give it a look. I haven't needed to pull through those details before. Look-out for a new video next Monday. 👍
New video up 🙌👍
Hi, after connecting Devops to powerbi when I select a data table then I see an error saying "Expression.Error: Access to the resource is forbidden" in the preview section. Please tell me what can I do to solve this.
This sounds like you may be accessing an azure devops project that you don't have permissions for. It's important to validate your permissions to data inside azure devops. Please double check this error message on the documentation or ask Copilot to help resolve this issue you're facing. Thank you for the question.
Thanks so much - super helpful. Do you know of a way to include the work item details as opposed to just the titles?
Thanks Tom. It's a bit more complicated. If you'd like I can make a video on that. Lmk if it'd be interesting?
@@PayingItForwardBE That would be awesome! And I suspect that I'm not the only one that would find it useful. Thanks!!
Will get on it tomorrow. Got some time.
Got 3/4 of the way there and got stuck. Getting help. This will be a good one. 💪
OK the new video on how to get additional details is up!
Thanks for the clear and great explanation. Could we connect to multiple Azure Devops projects using a single odata connection?
Thanks for the comment. Normally the odata connection basically formulates tables that you can then use to access your data in power bi. If you go into Power Query then you just need adjust the source (I think it is) with the other azure devops projects you want to present. You can adjust the url used to access projects as you get more familiar with the process of connecting to the data. Happy hunting.
@@PayingItForwardBE But what if you have many projects, would there be a connection for each project?
Great question. When you are crafting your odata connection for the first time you can determine the level you want to go to (org or project). In the example I go to the project level but you can also just put in the org. When you authenticate on the org level and then access the associated tables you'll see there is a table called projects. You'll need to then use this in power query to return a table or combine them altogether into a table with work items across projects.
If this would be beneficial let me know and I'm happy to record a video to demonstrate this.
How do we find the version number for odata link that you provided?
Do you mean the part of the url v3.0preview?
I've added my DevOps source but all of the columns that contain user names (i.e. AssignedToUserSK) are displaying as a long number sequence instead of the actual name. Have I done something wrong? How do I get it to write the actual name of a person?
Hi Asadt. Normally go be able to return the persons name you need the associated table which has the persons name in it. A relationship is then created between the two tables to associate the assigned to user sk, and the user sk will then allow you to present the various details of the user.
Off the top of my head I believe when you make the odata connection the table is called users. I'll look it up as not at my computer.
Yep it's the users table. More info on this link.
learn.microsoft.com/en-us/azure/devops/report/analytics/entity-reference-general?view=azure-devops#users
Brilliant Content. Will you please create a video on how to get time spent on a particular board column of Work Item in Azure Devops and report that in Power BI?
Thanks for the feedback. When you say time spent on a board column are you meaning the time a work item would be in a particular state? For example active, resolved or did you have something else in mind.
Thanks for replying. Actually I wanted to know how to calculate a waiting period of a feature. State doesn’t give much information about it. So we have added new board column as Hold/Blocked. Sometimes workitems move from Active to Hold then they again move back to Active then may be again to Hold. I would like to calculate total time of workitem in Hold column to calculate Work Item Flow efficiency.
May be another possibility is to calculate the time when Tag like ‘Blocked’ is applied to the work item to calculate the time it was waiting for something else.
Interesting. If I understand right you've defined custom swim lanes / columns on the board you're using to visualize the state of work items. I'm not sure if these custom swim lanes / columns leave a mark on the data history of a work item. Thats where I'd be able to do something like calculate the variance between when the states were changed. I'll have a look into the docs to see anything but my gut instinct says it's not possible.
@@PayingItForwardBE Is it possible to get this information using OData using tags? So when the item is blocked then tag is applied, when its unblocked the tag is removed. Is it possible to get that time when tag was on the workitem? Thanks for your reply.
Yeah that's an interesting idea. Tag data is handled differently. Let me take a look. What you could do (with power automate for example) is detect when a tag is added and then record that time slot in a database and they use that kind of data enrichment as a way of recording this. I provided an approach to this in another video when working with api calls. I'll take a look when back from vacation if the tag data "natively" has time stamps on it. Off the top of my head I don't think it does but I'll check. 👍
good video, how to get the information from the release pieline ?
Thanks for your question. Yes you can return the release pipeline info using an api call. I detail how to return api call info in this video.
ruclips.net/video/CINtyG6KsHw/видео.htmlsi=_G4tPNIL-BA4Vk_m
Search the api documentation for release pipeline info. 👍
Do you have a sample of fully developed Dashboard in pbi
Sure thing. I'll put it on my Github and link here.
You can find a sample Dashboard in the my GitHub repo, linked on the video description. Note, that it won't work until you update all the connections of the visuals to your own data which you'll have to prepare, but this should give you a place to get started from.