To work from Microsoft Excel and use the Team menu, you'll need to install Azure DevOps Office® Integration 2019.Ĭreate an Excel report from a flat-list query Team Explorer is free and requires a Windows OS. You can install Visual Studio from this download site. If you don't have Excel, install it now.Ī version of Visual Studio that supports the Team Explorer plugin, such as Visual Studio or Visual Studio Community. For a complete list of supported versions, see Azure DevOps client compatibility, Microsoft Office integration. To get added, see Grant permissions to view or create reports in Azure DevOps Server.Ī version of Excel that is compatible with your version of Azure DevOps, such as Office 2010 or later version. You must be a member of the TfsWarehouseDataReader security roles. If your on-premises application-tier server hasn't been configured to support reporting services, you can add that functionality by following the steps provided here: Add reports to a team project. Your deployment needs to be integrated with reporting services. You can generate these reports only when you work with an on-premises Azure DevOps Server that has been configured with reporting services. Here's an example of a status report generated from a flat-list query. To get the latest version of the Azure DevOps add-in for Office, install Azure DevOps Office® Integration 2019. If you want to export work items to Excel, see Bulk add or modify work items with Excel.

To learn more, see What are Analytics views? To learn more about process models, see Customize your work tracking experience. If your collection is configured to support the Inheritance process model, you can use Analytics views to filter work items and generate Power BI reports. For Azure DevOps Server 2019 and Azure DevOps Server 2020, supports projects that are defined on project collections configured with the On-premises XML process model.Azure DevOps Server 2020 and earlier versions configured with SQL Server Analysis Services.

This feature is supported for the following versions and configurations:

Azure devops open in excel