Uncategorized - Excelerator BI

Uncategorized

Introduction to DirectQuery

Level: Intermediate to Advanced Matt here.  I recently met Parker Stevens online through LinkedIn – he too is a Power BI fan, just like me.  Parker has shared a few techniques with me that I …

Introduction to DirectQuery Read More

What is DAX

I have written a series of articles over the last few years including: What is Power BI What is Power Query What is Power Pivot But I have never written an article about the DAX …

What is DAX Read More

PQL – Pronounced Peequel

Back in February 2016, I was tweeting with some others about the need for a new name for the Power Query Formula Language.  I came up with the name PQL, pronounced Peequel and made a …

PQL – Pronounced Peequel Read More

Convert a Cell Value into a Column with Power Query

Level: Advanced Power Query I am in the process of finalising some action items after a great Power BI, Power Pivot and Power Query training course in Melbourne.  During the training we looked at a scenario for …

Convert a Cell Value into a Column with Power Query Read More

M is for Data Monkey - Digital Edition

M is for Data Monkey Book Review

The long awaited book from Ken Puls and Miguel Escobar has just been released in digital edition.  I read this book over the weekend and wanted to share my experience with anyone considering buying this …

M is for Data Monkey Book Review Read More

Tidy Up Power Query

I have been doing a lot of work with Power Query for clients in recent months. It is not always obvious exactly what you need to do when you start writing a Power Query. As …

Tidy Up Power Query Read More

Excel Keeps Crashing? Check your VBA code

I use Excel 2013 64 bit and sometimes Excel just keeps crashing on me.  It used to happen to me a lot more in the past, but after I discovered what was causing the repeat …

Excel Keeps Crashing? Check your VBA code Read More

Solved: Power Query Issues with Power Pivot – Exception from HRESULT: 0x80020009

level: Intermediate I have written a couple of posts here and here about the problems and dangers of using Power Query with Power Pivot.  Well I am very pleased to say that I now fully …

Solved: Power Query Issues with Power Pivot – Exception from HRESULT: 0x80020009 Read More

Scroll to Top