Modifying the Analytics View’s Data to Report Visual Friendly Making the default data types from an Analytics View graph friendly means changing to a more readable format. The default data types for the fields in the analytics view are appropriate.… Read More »Transforming the Analytics View’s Data
Steps to Make the Area and Iteration Path Easier to View In some Azure DevOps projects we see long string values for Iteration Path due to nesting of iterations under common parent iteration. This long string value is not friendly… Read More »Shorten the ADO Area or Iteration Path for Easier Graph Readability
Adjusting the Analytic View and Propagating the changes to Power BI In some cases, you may need to make changes to the analytic view after establishing the initial connection. The most common scenario involves adding or removing a field from… Read More »Updating the Analytic View after it is Connected to the Power BI Data Model
Create a Single Dataset for Multiple Team Projects ADO users commonly write work item queries to construct dashboards or export data to Excel for reporting. Converting these queries into analytic views as the primary source of reporting on work items… Read More »Create Enterprise Azure DevOps Reports with Analytics Views
Using an Analytics View as the Source for your ADO Report The simplest way to start reporting with Power BI is to use an Analytics View as the source for Azure DevOps work items. Analytics Views are easy to create… Read More »Creating an Analytics View and Connecting to a Power BI Report