Blog

What is DAX - I have written a series of articles over the last few years including: What is Power Pivot What is Power Query What is Power BI But I have never written an article about the DAX language, so I thought I would cover this off today. What is DAX? DAX is an acronym for Data Analysis […]
Measure Dependencies in Power BI - Update:  Unfortunately after I released the latest version of my workbook in this article, something changed with Excel to stop the file working as designed.  At this stage I do not know what the issue is, but it seems to only affect the current channel versions of Excel.  I have just reinstalled the deferred channel […]
DMV to Extract Measures from Power Pivot - I have written articles before about how you can extract measures from a data model using DAX Studio and also using Power Pivot Utilities.  These are both excellent tools in their own right and I encourage you to read up on those previous articles to learn more about these tools. Today however I am going […]
Happy Second Birthday Power BI - The 24th of July, 2017 is the second birthday for Power BI.  I thought I would take the occasion of its second birthday to reflect on all the great work that the crack Power BI team at Microsoft has done over the last year.   I think it would be a tough job working in […]
When to Use SUM() vs SUMX() - It has been 2 years since I first wrote an article about SUM() vs SUMX().  I decided to write a new article to refresh this topic and add in the things I have learnt over the last 2 years. SUM() vs SUMX() First let me start with an overview of both of these functions. SUM() […]
The ALL() Function in DAX - In this article I am going to write about the ALL() function, show how it works and explain a common use case.  I will also cover the unexpected behaviour that occurs when using the ALL() function in Power BI Desktop – more on that later. For this article I will use my simplified copy of […]
Understanding Power Query Combine - Sometime late in 2016 Microsoft deployed a new “Combine” feature in both Power Query for Excel (Get and Transform) and also in Power BI Desktop (Get Data).  The new capability makes it easier to combine multiple copies of similar workbooks into a single table without hand coding M Functions, but unfortunately it is now a […]
Power Pivot Crashes–Another Update from Seattle - When I was at the Microsoft Data Insights Summit last week I took the opportunity to catch up with Howie Dickerman to get an update on how the bug fixing with Power Pivot for Excel is coming along.  I talked about this in my original blog here and then my previous update here.   And the […]
My MDIS Presentations - As those that read my blog regularly would know, I have been at the Microsoft Data Insights Summit in Seattle Washington for the last 2 days. I had the privilege and pleasure of presenting two sessions at the event. For those that were not able to attend, here are the videos of my sessions. DAX […]
Secret Insider Update on New Power BI Features From MDIS - Today I sat through the Keynote session at the Microsoft Data Insights Summit.  As expected, James Phillips confirmed that MS has been holding back a few killer features to announce at the Summit.  Here is the list of new things that are coming that I wanted to share with you – I am truly excited. […]
My MDIS Data Analytics Challenge Entry - I was reading a blog by David Eldersveld last week where he was talking about his entry in the Microsoft Data Insights Summit Data Analytics Challenge.  I originally was too busy to enter however I was inspired by his article and thought I should prepare an entry albeit with only a few days to go.  […]
Microsoft Announces the Return of Export to Excel - At the start of May 2017, Microsoft announced that Export to Excel/CSV would no longer be available to Power B Free users, and would not be part of the new Power BI Premium offering either. Today Microsoft announced that it has listened to community feedback and has agreed to include this feature for all users again. […]
Power BI Free is the Main Problem Here - I am an enthusiastic sponsor of Microsoft BI. I have been fortunate enough to build a new career off the back of the great products Microsoft has developed, specifically Power BI, Power Pivot and Power Query.  Having said that, I am definitely disappointed with the new licensing agreement changes have been released in the last […]
Power BI Licences Changes–The Good, The Bad and The Why - Microsoft today announced that it is changing the way it licences its Power BI service product.  I want to provide my personal view on why it is doing this, what is good and also what is bad about this change. The Problem MS is Trying to Address Let me start by explaining the problem that […]
How and Where to Get Help for Power BI - Regardless of what stage you are at in your Power BI/Power Pivot/Power Query journey, at some stage you are going to need some help.  Believe me I am no different to you – we are all learning and we all need help sometime or another.  There are basically 3 options that I want to talk […]
How to Find Overlapping Pivot Tables - A client contacted me recently and asked me to solve a problem for them.  They have a large Power Pivot Excel workbook with lots of Pivot Tables.  All was good except sometimes when they refreshed the data, the newly loaded data changed the shape of some of the pivot tables causing at least one of […]
New Power BI Reports from a Golden Dataset - Last week I wrote an article at PowerPivotPro.com explaining how to create a new report on PowerBI.com that connects to an existing dataset already loaded on PowerBI.com.  I then discovered (thanks to reader feedback) that Microsoft has already delivered a preview of a new feature called “Power BI Service Live Connection”. This new feature allows […]
Which to Use – Power BI or Excel? - Level: Beginners One of my regular blog readers (and graduate of my live training course) Phil Cross asked me last week if I knew of anywhere to find a comprehensive guide for Self Service BI users of when to use Excel vs Power BI to author new data models. I thought this would make a […]
Quick Measures and Query by Example - 2 fabulous new updates again in the April update of Power BI Desktop.  Here is my quick review so you can see how great these things are. Quick Measures Quick measures are designed to help you get started with DAX, without knowing any DAX!  OMG I will be out of a job!! Once again this […]
Power BI Desktop – Memory Usage - Some time ago I developed a tool that allows you to automatically connect a local Excel Pivot Table to a local running instance of Power BI Desktop.   You can read that original article here if you like.  It works kind of like Analyze in Excel but using Power BI Desktop running on your local PC […]

Ten Things I Wish I Knew When I Started With Power Pivot.   Learn  Without The Pain!

x