Category: Tip

Prevent data source changes from breaking your Power BI model! This technique allows your data models to refresh while giving you time to address the change

I was working with some bookmarks in a Power BI model earlier when I noticed that in some cases the Filter pane was expanded and in other cases, it was collapsed. I was intrigued so I started investigating. It seems when you save the bookmark, it now retains the open/close state of the Filter pane. […]

It’s that time again and if you are headed to Microsoft Ignite 2017 and are overwhelmed with the session choices, here’s some recommended sessions to check out. Power BI – Microsoft Ignite 2017 If Power BI is your interest area, here’s some great sessions to check out. Dive into effective report authoring using Microsoft Power […]

This post shows you how to use the date hierarchy and the grouping function to easily group your data by year, month, week in Power BI. This can be very handy when reporting against data that is time phased, such as sales transactions or Project Online schedule and capacity data. If you need to start […]

Power BI’s Donut charts are very attractive. When used improperly, they make it harder for the user to read the data. In this segment, see how a donut chart has been used improperly and learn a better way to show the data.

Microsoft has released the 2013 version of the Project Portfolio Management (PPM) guide for Project Server 2013 and Project Online. You can download it here. http://www.microsoft.com/en-us/download/details.aspx?id=41549  

At some point, you will be asked for information by Fiscal Year. The Fiscal calendar was set up in Project Server so it should be accessible for reporting, right? A fair number of companies have fiscal calendars which don’t exactly line up with the standard calendar which can cause some challenges. You could hard code […]

A successful configuration of Project Server is one that supports the conversations within the organization. Users have to go beyond use of the system and have concerns over the validity of the data entered. The Project instance captures the requisite information for the conversations and enables participant to synthesize additional outputs and insights. Therefore, an […]

If you’ve ever attempted to include content from a Project multi-line text custom field or Issues multi-line fields in an Excel report, you will get a result that looks like this: <div><p>Vendor is having issues with deliveries to the East Coast.</p></div> At the 2012 Project Conference, I presented a SQL based solution that converts the […]