This week we were working on an Excel Services report that pulls data from Project view tables, Resources, Tasks and Assignments. Luckily, we have Power Pivot available to help join these tables, right? We started pulling the tables one at a time using the Data/From Other Sources/SQL option. We enter the server name and our […]