It would be insane on my part if I don't appreciate your commendable work in explaining these concepts...Thanks a ton Especially the Reports part is so helpful for Agile Project Managers like me..Ravi,I was able to create dashboards showcasing number of features,PBI,bugs done per release in Azure..Credit goes to you..But 1 challenge I am facing is unable to get how to derive when these are done...I mean for say I have 85 features in done state for Jan...how many days it took to get them done...Confused between CFD chart or lead time...which 1 I should select..Do suggest if something else is there to reiterive such data
Thank you so much for the video! I applied few filters in the Analytics view, but it is loading complete data into power BI without any filters.. how can I get only filtered data into PowerBI
How do I bring project capacity to power bi? I can take several projects to power bi and then make a comparison between the projectsCan I take several projects to power bi and then make a comparison between the projects?
Hello Ravikanth, Thank you for this amazing video.. However when I connect my data having multi line values or dropdown valies with Power BI, in Power Query editor it is showing blank.... Is this some limitation ?!
Hi Ravi, I have built a Dashboard, now there is new data in Azure, when it will be added to the existing Board? is that we have to perform Refresh Manually? If so how to do it please explain. Thanks.
Hello, My employer doesn't have the On Premises Azure DevOps so I cannot get to the Analytics View, is there any other way to do it? I want to see Backlogs differently, all I can pull now is altogether Stories, Tasks, Work Items, Bugs
So apparently, I have some problem to extract the data from Azure Devops into the power Bi. In the Get Data option, I already took the option Azure Devops (Boards Only) and it did extract the data, but some of them is missing, the tags. And the missing one is very important for me, i couldn't extract the tags element in the Azure Devops and i did do it multiple times, but the tags just wont show up in the Power Bi query editor. Can someone help me on this, thanks in advance!!
Hi @Ravikanth I was trying to implement azure entries to trigger specific test cases. ie. i have an excel sheet for the test suits taht i have and i run them with y/n flags. and inturn the test cases also have y/n flags to proceed with execution. can i eliminate the excel and make the changes on the pipeline(using run time parameters) to set up the builds?
Hi, I have tried to do the same as shown in the video but my results are not accurate. I am able to see duplicate entries in the data. If you ask what duplicate entry it is "if I go back and make any changes in the work item then it is taking as a new entry with the same id and same Info. If I eliminate the duplicates manually in powerbi and create a dashboard initially it will give accurate results but end of the month if I pull the report from power bi I may see many duplicates. Is there anyway I do not have to eliminate duplicates manually and get the accurate data.
Tqs Ravi kanth now i am getti9ng some confidence in my work when i saw your video wch is discuss on MS Devops
Thank you and please subscribe to my Chanel
Thank you ! Easy to understand and follow up
Thank you and please subscribe to my channel 🙏
Congrats for your video! It helped me a lot!Congrats for your video! It helped me a lot!
Thank you and please subscribe to my channel
thank you for this vid, super helpful
Glad it was helpful! Please do subscribe to my channel
Thank you for sharing your knowledge.
Thank you and please subscribe to my channel
It would be insane on my part if I don't appreciate your commendable work in explaining these concepts...Thanks a ton
Especially the Reports part is so helpful for Agile Project Managers like me..Ravi,I was able to create dashboards showcasing number of features,PBI,bugs done per release in Azure..Credit goes to you..But 1 challenge I am facing is unable to get how to derive when these are done...I mean for say I have 85 features in done state for Jan...how many days it took to get them done...Confused between CFD chart or lead time...which 1 I should select..Do suggest if something else is there to reiterive such data
Hi Ravikanth. This video is really informative. Is there an option to fetch the Test case execution status to power BI?
Thank you so much for the video! I applied few filters in the Analytics view, but it is loading complete data into power BI without any filters.. how can I get only filtered data into PowerBI
Hello!!
First, great video! Thanks for the teaching!
How can I import column name? In the query does not display this option :(
Really useful. Thanks much
Please subscribe to my channel
hello, please which tool do you used so that you are visible inside the share windows, or to used share windows as background. thank you
Great, thanks
Glad you liked it! Please subscribe to my channel
powerbi vs azure devops , which one is better for non it background guy and easy to work in the organizationn
It's all depends are the requirement. Power BI is BI tool for reporting purposes. Azure DevOps is for project management and for CI/CD pipelines
Error: ACCESS TO THE RESOURCE IS FORBIDDEN.
Do I need any license or special rights to access the data of my project in ADO Board?
Hello Sir, thank you for your videos. Since PowerBI has only 250,000 limit, what are some reporting alternatives to use instead of PowerBi?
Can we marge more than one project and get it in a single table in Power BI?
How do I bring project capacity to power bi?
I can take several projects to power bi and then make a comparison between the projectsCan I take several projects to power bi and then make a comparison between the projects?
Растянул использование стандартного коннектора Azure в Power BI на 34 минуты, это победа
Hello Ravikanth,
Thank you for this amazing video.. However when I connect my data having multi line values or dropdown valies with Power BI, in Power Query editor it is showing blank.... Is this some limitation ?!
How do you load the comments from DevOps into PowerBi. The client is wanting to see comments loaded from the work items
Hi Ravi, I have built a Dashboard, now there is new data in Azure, when it will be added to the existing Board? is that we have to perform Refresh Manually? If so how to do it please explain.
Thanks.
How do i setup variable for notification via email of PowerBi reports in pipeline?
What ever you have showed in Video can be achieved even on azure devops dashboards right??
Yes, but power BI is the used by most of the higher management
Hi @Ravikanth - is there a way to connect Analytics View to Excel ?
Thank you
Thank you and please subscribe to my channel
Do you need a tenant account to connect to the data? If not what rights do you need cause I don't have acces with only member rights.
How do I pull the pipeline data into power bi?
what if I create a User story in devops and refresh the Power BI report would it show up in power bi report which I created?
Yes, it should
@@RavikanthReddy It does not show up one deployed\published the data does not refresh
can I import data from organization only and not paste the team project?
In my organisation, we use Azure DevOps CLOUD and the extension isn't available. Is there any alternatives?
How can i get queries from azure devops in power bi?
One question: How is it possible to extract the iteration start and end dates from Azure DevOps to a Power BI table? Thank you!
Hello Ravikanth,
Do you know how to do the same using dataflows instead of datasets?
How Azure DevOps Cross-Organization Reporting and Analysis using Power BI can be done
When i trt to connect it gives error like resource access is forbidden. How to connect with devops??
Is it possible to implement a Dashboard pipeline for all project ?
Yes, it is possible as long as the projects are within the same organization
@@RavikanthReddy any tips how we can do this?
How to load all projects single time.
Hello,
My employer doesn't have the On Premises Azure DevOps so I cannot get to the Analytics View, is there any other way to do it?
I want to see Backlogs differently, all I can pull now is altogether Stories, Tasks, Work Items, Bugs
So apparently, I have some problem to extract the data from Azure Devops into the power Bi. In the Get Data option, I already took the option Azure Devops (Boards Only) and it did extract the data, but some of them is missing, the tags.
And the missing one is very important for me, i couldn't extract the tags element in the Azure Devops and i did do it multiple times, but the tags just wont show up in the Power Bi query editor. Can someone help me on this, thanks in advance!!
I was only able to get tags when I ran a query, added tags as a custom column, and then selected open in power bi from the query
Hi @Ravikanth
I was trying to implement azure entries to trigger specific test cases.
ie. i have an excel sheet for the test suits taht i have and i run them with y/n flags. and inturn the test cases also have y/n flags to proceed with execution. can i eliminate the excel and make the changes on the pipeline(using run time parameters) to set up the builds?
Hi,
I have tried to do the same as shown in the video but my results are not accurate. I am able to see duplicate entries in the data. If you ask what duplicate entry it is "if I go back and make any changes in the work item then it is taking as a new entry with the same id and same Info. If I eliminate the duplicates manually in powerbi and create a dashboard initially it will give accurate results but end of the month if I pull the report from power bi I may see many duplicates.
Is there anyway I do not have to eliminate duplicates manually and get the accurate data.