Since TFS 2005, you have had the ability to open work item queries in Microsoft Excel, allowing the user to view the query results in Excel, as well as make changes and push those changes back to TFS.

TFS 2010 uses SQL Server Reporting Services to provide reports, but because it uses data warehouse and analysis services to store reporting information, users can roll their own. We examine how to use ...

Figure H Save the data to Excel. Flash Fill was definitely quicker, but knowing the Power Query method will help when you’re already working with data in Power Query.

If you’re looking for a straightforward method to automate the generation of Excel reports, such as those for end-of-month financial results, there is a simple solution that can save you time ...