When Project Online was first released, there was no mechanism to refresh Excel reports consuming OData feeds. Users were encouraged to open the Excel reports and manually refresh the reports. Macros were written. Hair was pulled in frustration. Somewhere after the release, Microsoft came up with a clever solution – which involved basically routing the […]
When Project Server 2013 first came out in an online and on-premises version, I began porting some of my demo reports over to the new online environment. The goal was to see what worked, and what didn’t work, and what new skills I would have to acquire to achieve reporting parity between the online and […]
Working on a new set of demos for Mike and my upcoming Project Conference presentation. Figured I’d mention this little tidbit…. As I was trying to use PowerQuery to surface OData from a Project Online, I seemed to have run into the same issue that I’ve had with LINQPad, i.e. not being able to authenticate […]
I realized that yesterday’s post may have given the incorrect impression that you need to go through all sorts of mind bending contortions to get timephased reporting out of Project Online. The reality is that you’d only have to limber up if you wanted to do reporting like I showed yesterday, i.e. a detailed view […]
Catching up on the blog comments after a couple of weeks of vacation and post-vacation wheel spinning. One of the comments that caught my eye was Bram de Vries’ comment on a previous reporting post: Do you think I need to jump through all these kinds of hoops to create a report where timephased assignment […]
This question comes up in the forums pretty frequently, and in fact, I’d actually spec’d out a similar procedure for on-prem Project Server installs which involved hitting the Reporting Database to figure out the Project Owner. I am not sure how useful this code really is, but I was curious about how hard it would […]
I’ve been leveraging this report in my demos for a couple of years now – basically an overview of all of the major milestones in the project portfolio color coded by schedule status. Figured I’d test my newfound OData skills and see how hard it would be to recreate in the new world of Project […]
Now we have an Excel workbook with the appropriate data connections to Project Server…. Let’s break out PowerPivot to modify the data model. Click on the Manage button in the PowerPivot tab. You should see something that looks like this: Rename the tabs to something a bit more useful. Now let’s add a custom field […]
In this post, we’ll create the appropriate data connections to pull the data from Project Server OData into Excel 2013. To do this, we first need to do a bit of analysis on the required data. As we already have a working version of the report using SQL queries, we can break down the technical […]
As part of my preparation for the upcoming SharePoint Conference, I decided to embark on an exercise to port some of my more popular reports over to OData and Project Server 2013. Indeed, it turned out to be quite the mental exercise – and hopefully I didn’t end up with the cranial equivalent of a […]
Project Epistemology 