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 …
Uncategorized
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 …
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 …
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 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 …
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 …
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 …
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