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
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 helpful, and it took a long time to resolve it. In the end it turned out to be […]
Using Row Level Security to Auto Filter your Power BI Reports
Without a doubt I think Power BI is one of the greatest tools Microsoft has released in the last few years, it truly has revolutionised and democratised data (oh no, I’m beginning to sound like a Microsoft employee). What I really meant to say is that it’s made accessing Project Server data really easy […]
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 create a data calendar – please note no warranties etc are implied by publishing this code. /* Power Query Code (M-code) to create date table Modify the StartDate and EndDate values as necessary for your data */ […]
#PowerBI World Tour
I’m really pleased to announce that I’m presenting at the Power BI World Tour at the London event on 23-24th August 2017. This is a great opportunity to learn more about Power BI and to mix with your peers and industry experts. For those of you who can’t get to London then the tour includes […]
#PowerBI on the TechNet UK blog
#ProjectOnline #ProjectServer #PowerBI #PowerQuery #BI #Office365 #Excel #PPM Just a quick plug for an article I recently wrote for the TechNet UK blog – it’s an expansion on a previous blog and works as an introduction to PowerBI with Project Server and is available here… http://blogs.technet.com/b/uktechnet/archive/2015/12/29/is-power-bi-the-christmas-present-you-were-waiting-for.aspx Whilst I’m at it, other noteworthy resources for PowerBI […]
#PowerBI with #ProjectOnline #Office365 #PPM to view Resource Work by day
Recently I’ve been working with a customer on getting a simple way of displaying resource information. In truth I started with manipulating data in Excel using VBA, but quickly realised that there was a better way to do this using PowerBI. The end result (or rather the 1st iteration) is a report which has the […]
Getting at Task Notes in Excel or other reports from Project Server
As usual, most of my posts are inspired by customer requests (I don’t sit at home thinking up scenarios to blog about regardless of what my wife thinks!), and this one turned out to be surprisingly easy to resolve, even though I initially went about it the wrong way. The request was fairly simple, to […]
Do you want to find out more about Reporting in Project 2013?
[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 asked me to give a presentation on Project 2013 Reporting – I did one for the MPUG before Christmas, so I’m excited about running this again, only this time […]
Moving SQL Servers
Over the summer I spent a couple of weeks in Mallorca on holiday, and whilst there prep’d up moving SQL servers (who needs a holiday when you work for yourself!). Prepping all this was because one of my customers wanted to migrate all of their Project Server data (and associated WSS data) to a new […]
SQL Server Native Client – 64 bit – Failed to build the OLAP cubes
Just a quick reminder that if you’re struggling with getting Analysis Services to build successfully one of the errors you might see is …. Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server BenHowardSQL08. Error: Cannot connect to the repository. Analysis […]
Cannot overwrite an OLAP database created outside of Project Server or by another Project Server Site.
*** Update *** I came across this blog recently – this is a much better way forward. Thank you Martin – http://www.kulov.net/blogs/martin/2009/08/overwrite-olap-database-problem.html *** End of Update *** Generally I don’t blog technical issues as there are lots of good technical blogs out there, but as no-one else seemed to have blogged this I thought I […]
Fun with Analysis Services!
Gee’d on by too many nights in hotels, I started briefly messing around with Analysis Services, and I started thinking that there must be so much you can do with this tool than the basics that you get out of the box. My main reason for this was that I wanted to get a view of […]
Migrating from MSDE to SQL2005
This blog is a move away from the scenario based blogs on PS2007 that I’ve been writing, instead it’s an overview of a situation that I think will become more common as organisations upgrade their project server databases (and WSS2.0) to SQL2005 (either from SQL2000, or in some cases there is a requirment to do […]