I am currently working on a project that involves using Azure DevOps as the main management tool. However, our team has decided to analyze the data generated in the platform through Power BI reports. As such, there are some attachments in the work items that we would like to see displayed in PBI, is there any way to do this?
1 Answers
There are multiple ways to connect to the powerbi to devops and get the work item data. Such as by using analytical view, oData queries and oData feed, etc.
To Create power bi reports using analytical view first you have to import data in the power bi, this can be done by selecting
azure devopsas an option in theOnline servicetab which itself is in theget datatab in thepowerbi destop app
getdata -> online options -> azure devops
After that it will ask you for organization and team and ask you to login to your devops account too.
After this a popup will immerge and in which you can select the work items data based upon the duration time which has passed such today, last 30 days, entire history, etc.
Refer the following documentation
Related