Quick Hack to create a Lipstick Chart in Power BI
Use this Power BI template to report on Labels from you P4W projects.
Error when loading a new query – OLE DB or ODBC error 10 keys were specified, but 5 values were provided
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 BI when trying to add in an additional query. The screenshot of the error message is displayed below. The error isn’t hugely […]
Project Solution Accelerator
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 Web (P4W). The accelerator is being developed by Microsoft and will include items such as project requests, issues, risks, programmes, and will create some additional functionality for P4W to bring […]
A whole host of Power BI content – Power BI Lunch and Learn and the Manchester Power BI user group
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 working in both Power BI and using the similar tools in Excel (for those of you who didn’t know Power BI was “born” in Excel, or at least as an […]
Planner Tasks Power BI Template on GitHub
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 template, and move it over to GitHub. At the same time I recorded a video of how to use the template file – I didn’t cover the whole of template […]
Updated Planner Tasks Power BI Template
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 include the Priority field. Microsoft have now included the Priority field in their own charts as blogged here by the product team. Here’s the Priority visual spotlighted in my Power […]
Planner Tasks now have a Priority field
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 can be Urgent, Important, Medium (default) or Low. Setting of the priority is easy, but what’s really nice is the ability to filter and group by priority as displayed in […]
PowerBI Template for Exported Planner Plans
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 been created, one to display the tasks by priority, and another with a buttons to switch easily between the status or priority views. As well as links to the template […]
Updated PowerBI Template for Project Online
Updated Power BI Content Pack – drill through and buttons! <coffee> Power BI has definitely become my favourite application (after Project of course) in the Microsoft suite simply because of its power and versatility. In the past I’ve taken Microsoft’s standard content pack (available here) and modified it to expand the number of languages […]
RAG Status and PowerBI Reporting – #PowerBI #ProjectOnline #O365
<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 that here’s a shameless plug for a Power Query course I wrote year ago here. Moving forward it’s fair to say that every Project Online/Server implementation I now do has some […]
Gantt Charts in Power BI part II #ProjectOnline #PowerBI #GanttChart
It came to my attention recently that my previous post on Gantt Charts in Power BI needed slight modification in order to display the correct length of the Gantt bar. In the post I used the ProjectDuration to display the duration on the Gantt bar, however this is held in “working hours” and not […]
Gantt Charts in Power BI
Over the last year or so Power BI has made a real charge to become THE reporting tool for many applications, including of course Project Online. There are lots of great things about Power BI (and some not so great too!), including the very quick release cycle (dare I use the word agile!). Whereas Excel […]