Quick Hack to create a Lipstick Chart in Power BI
Use this Power BI template to report on Labels from you P4W projects....
Use this Power BI template to report on Labels from you P4W projects....
Use this Power BI template to report on Labels from you P4W projects....
OLE DB or ODBC error: [Expression Error] NN keys were specified, but N values were provided. <English Tea> I recently had an issue in Power...
Introducing Teams Apps for Project and Microsoft Roadmaps <English Tea> There have recently been a couple of apps introduced into Teams that consolidate the Microsoft...
Microsoft's Solution Accelerator for Project <Frothy coffee> One of the major announcements at Ignite was a solution Accelerator for the new Project, aka, Project for the...
Power BI Lunch and Learn and the Manchester Power BI User Group <Frothy coffee> Over the last four years I've spent a lot of time...
Planner Template on GitHub <Ice Cream> Microsoft are retiring content on TechNet, and so I've taken this opportunity to slightly modify the Planner Power BI...
Planner Priority field #2 <Tea> It's great when Microsoft copy one of your ideas :) Back in Sept 2019 I updated my Planner Template to...
Keeping track of the current plan and a couple of baselines! <Wasser> Project has the ability to hold 11 baselines, and I'm often asked to...
Planner Priority field <Tea> This is just a quick blog post to say that Planner now includes a priority field for each task. The priority...
Power BI Template for Planner Plans <Update 10th September 2019> The Power BI template now supports the Priority field, and an additional two tabs have...
Updated Power BI Content Pack - drill through and buttons! <coffee> Power BI has definitely become my favourite application (after Project of course) in the...
Auto Calculate is switched off by mistake (CTRL-F9) Recently one of my customers was having an issue with Project not "behaving"correctly. As I was...
Introduction This article discusses Project and Excel integration points, specifically in the following areas: How to import data from Excel to Project Importing an...
Changing the Permissions Mode in Project Online Introduction This is really the briefest of blogs to let you know of a UI change away from...
Managing Sprints and Agile in Project Introduction This is the second in a two part series covering the Agile capabilities of Microsoft Project. In the...
<flat white (again)> Using Row Level Security to Auto Filter your Power BI Reports Without a doubt I think Power BI is one of the...
<Tuborg> Using Kanban Boards in Microsoft Project Introduction There has been a lot written over the last year regarding Microsoft’s foray into the world of Agile...
<G&T> Modifying Microsoft’s #ProjectOnline #PowerBI Content Pack to Support Your Language - Polish, Russian and now Polish. <180822 - Update> A quick note of thanks to...
<G&T> Modifying the Menus in Project Over the years I have run hundreds of training courses and one of the issues I often hear from...
<soup> Creating a Date Table in Power Query Simply because this asked for recently, here's some M-code that you can paste into Power Query to...
<Flat white> Modifying Microsoft’s #ProjectOnline #PowerBI Content Pack to Support Your Language This article shows you how to modify Microsoft's standard Project Online Content Pack...
<Tetley Tea> Project Online Work and Capacity Graphs in Power BI - solution starter A lot of my work now revolves around producing Power BI...
<flat white> Creating Resource Work and Capacity Graphs in #MSProject A customer posed the challenge earlier this week of producing a work and capacity report...
<tea> European SharePoint Conference 2017 At the back end of last year I was honoured to be able to speak at the ESC2017, the second...
<coffee> Microsoft have very recently released their latest content pack for Project Online and details can be found on the Project Support...
<tea> Microsoft Project has long been considered as a tool that can only be used with structured , rigid tasks. Typically this...
<tea> There has been some speculation that Microsoft might provide a link between MS Project and Microsoft Planner for quite some time, and now...
<you’re just as sane as I am> I’m happy to announce that my latest course “Portfolios, Programs and Projects: What’s the Difference?” has just...
<Nothing more interesting than tea…> I’m really pleased to announce that I’m presenting at the Power BI World Tour at the London event on...
<East London Brewery Jamboree> If like me, you’re based in the UK and you deal with organisations based in Scandinavia (and others of course)...
Happy to note I’ve been re-awarded as an MVP for Microsoft Project again, for the 9th year running :) ...
<tea> I’ve been a massive massive fan of PowerBI for some time now, and an even bigger fan of Power Query; so much so...
<ice cream> I’ve been meaning to write about Durations for a while, and was inspired to get a move on when I read fellow...
<white cappo> One of my customers recently commented that his projects always had a start date of 12th October 2009… After some investigation it became...
<coffee> Take Project Online from 0-60 in 1 Hour I’m delighted to say I’ve been selected to speak once again at the European SharePoint Conference...
<frothy coffee> One of the nice things about the Project Online licence model is the occasional new feature which magically appears. As of this...
<mineral water> I was lucky enough to be invited back to Kyiv by fellow MVP Oleksiy Prsonitskiy to present at the Ukrainian Project Conference. ...
<coffee> One of my customers recently wanted to calculated %Planned for each task (and therefore each project). They had done a little research on...
<tea> Some of the clients I work with are really big, and some are really small. The smaller ones tend to want things that...
It came to my attention recently that my previous post on Gantt Charts in Power BI needed slight modification in order to display...
<Coffee> Introduction Over the months and years I’ve seen a tonne of issues regarding the ability, or inability to edit Enterprise Calendars. I started a...
Over the last year or so Power BI has made a real charge to become THE reporting tool for many applications, including of...
<coffee> I recently ran an MPUG session integrating Project with Excel. Part of the presentation was using the Visual Reports feature and exporting the...
<baileys> Typically I don’t blog about service packs, feature packs, CUs, PUs and anything else release related, however, this time I’m making an exception...
<jana mineral water> I’m delighted to be have presented at the SPC Adriatics 2016 on a couple of topics regarding Project Online, and decided...
UPDATE 16/05/2017 This issues still plagues me, but on Project 2016 and not Project 2013. I removed several unused accounts from the Project Web...
<Tomato Soup> One of the main configuration items with respect to Project Server / Project Online is the creation of project level Enterprise Custom...
#ProjectOnline #ProjectServer #PowerBI #PowerQuery #BI #Office365 #Excel #PPM <tea> Just a quick plug for an article I recently wrote for the TechNet UK blog –...
<Frothy Coffee> Recently I’ve been working with a customer on getting a simple way of displaying resource information. In truth I started with manipulating...
<ice cream> In this series of blogs, I’m going to try list the differences between Project 2013 and Project 2016 – I’ll...
<tea> It’s a bit of a mundane topic this one, but like all of my topics, it’s soooo real world! I have a customer (okay,...
<Early morning coffee> When it comes to Risks and Issues, I find that many of my customers wish to transfer their existing Risks and...
The Project MVP community is hosting the 1st ever Project Virtual Conference. Running for 24 hours on the 22nd October, it encompasses the...
[Coffee] Modifying an existing project site, saving it as a template and then associating that template to an EPT is something that I’ve been...
<homebrew, tea, wine, coffee and several other beverages – this blog was written over several days!> I’m currently helping manage a multiyear schedule and...
<merlot> I came across an issue the other day whilst dabbling in a demo project update. The issue was that I couldn’t set the...
<San Servolo, Tanqueray & Red Wine – this has been written over a long duration of time!> I was thinking about the top 5...
<Ožujsko> So perhaps the title of this blog is a little over the top, but I had a customer recently who needed help when...
<Tuborg Guld> It’s really nice when someone takes an idea and runs with it, creating something that is bigger and better than the original;...
Update – 140717 – The recordings of the sessions are now available on Microsoft’s channel 9 (here and here) and in case they...
<latte> It’s been a while since I last discussed Teams and Team Resources, and having learnt something new recently (kudos goes to Eric Uyttewaal...
<chimay> Back in March this year, I presented a webcast for Microsoft called Sharing and Collaborating with Microsoft Project. If you’re interested in watching...
<A beer in London - £4.30!> Most problems (or opportunities of course) arise from customer queries; really, if it wasn’t for you guys keeping...
<Decaf coffee> I was lucky enough to attend and present at the Project Conference 2014 in Anaheim, California. This is the bi-annual Project “love-in”,...
<Earl Grey> Change highlighting is beautiful, but there are times when you do not want to display it, for instance when you want to...
<thé> As usual, most of my posts are inspired by customer requests (I don’t sit at home thinking up scenarios to blog about regardless...
When I review the statistics on my blog, one of the most popular ones is Exporting tasks into Outlook - http://applepark.co.uk/exporting-tasks-from-project-into-your-outlook-calendar/. I’m not...
<Affligem> When you first open Project 2013, you are presented with a series of templates… this is a new (and on the whole pleasant...
<London Pride> These days we are presented with different options and price points for utilising on premise or on line services, and as a...
<tea> In case you missed the announcements, TechED Europe is happing in Madrid from the 25-28th June. Though I’m not speaking this year, I...
<macchiato> Promising to keep the blogs going, but with a bias towards Project and Project Server 2013 (check out the book here…), I thought...
<Double expresso> If you didn’t already know, Microsoft provide an out of the box solution to integrate Project Server and Team Foundation Server called...
<Expresso> [UPDATE] – the link to view the recording of the presentation is here <Haagen-Dazs ice cream> Save the date – 6th March 2013 Microsoft have kindly...
<Cafe creme> Cost resources are a very useful feature of Project (and also therefore of Project Server), but there is at least one rule...
One of the greatest things about Project 2013 is the new reporting section. The old tabular reports have been pulled, leaving us with...
I’ve recorded my experience of installing Project Pro for O365 using click 2 run (C2R) over a public WIFI (<2mbs) – parts 1&2...
Update – just so you know I was there… Just to say I’m going to be at the “ask the experts” stand at TechEd,...
Just to say I’m going to be at the “ask the experts” stand at TechEd, answering questions on Project, Office and O365. It...
<ipa> The majority of projects I’m involved in concentrate more on people and process than anything else (some customers really want to think “tools,...
<Tazza (and Led Zeppelin (Dancing Days) on the radio, thank goodness for BBC 6 Music)> So, you know who you are, and I said...
<Earl Grey> Project Server 2010 allows for the option of auto-approving task status updates, and since SP1, this has become even more useful as...
<Guinness> This is something that in the past I have done manually, but due to a discussion on a Web2.0 application somewhere I had...
<flat white> I’m starting to see this small issue more and more, as Project Server deployments become global in nature. The issue is around...
<Leffe Blond> This requirement came from a customer more as a general query rather than a full demand, but I thought it should be...
<Cool cold water> I seem to spend quite a bit of time, during training courses, explaining (in some depth) how Project Server security works. ...
<Yorkshire tea!> I rarely re-blog existing blogs, but I thought this one was worth it. MS have just released the grandly named Microsoft Project...
<Youngs bitter> A customer on a recent training course asked if how he could create a view that didn’t display dates, but rather showed...
<baileys> Resource Departments In my last blog I introduced the concept of departments. Let’s now look at how departments can be used with resources. When...
<decaf coffee> Introduction This is an introduction to Departments, where they are used and how they are set up. I intend to follow up this...
This is a nice little trick, that I've used several times at client site to slow both optimistic and/or pessimistic durations on a...
<coffee> Apologies for those who've read my blogs before, but as I've created a new web site I wanted to make sure all my...
<earl grey tea> When I talk to customers about Project Server and task management, one of the things that really catches their eye is...
After presenting and helping co-ordinate MPUG (Microsoft Project User Group) meetings in Manchester and London, UK, we’ve decided to widen our potential audience...
<Earl Grey> This is off-topic for my normal postings, but I just wanted to congratulate MS on the ease, over the last year or...
<Pinot Grigio – it’s been a long day!> As previously blogged, I was recently invited to speak on Project 2010 at the Microsoft UK...
<cup of tea> MS UK recently held a week long series of events here in the UK called techdays - http://www.microsoft.com/uk/techdays/. I was given...
<hot water and lemon> I’ve been troubleshooting an existing PS2007 implementation recently (obviously not one that I set up!), and the customer was having...
<dry and feeling much better for it – thanks for asking> So, on 25th Jan I ran a webinar for Microsoft on Project 2010,...